(Say you name your Sheet1 to Database, but when you open up VBE, under
Project Explorer, you see it as "Sheet1 (Database)".

Also, I realised something too, the reason why the test code work is because
I didn't name any of the sheet.

dont confuse the .Codename with the .Name property

when you use Ado you can only use the .Name
(which is the one you see on the tab in Excel
and see inside the brackets in VB project explorer

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam

?B?YXVndXN0dXM=?= wrote in message
:

(Say you name your Sheet1 to Database, but when you open up VBE, under
Project Explorer, you see it as "Sheet1 (Database)".

Also, I realised something too, the reason why the test code work is
because I didn't name any of the sheet.