View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Excel export to Access - Run-time error 1004

Hi again Ralph,

I decided to do a search for where you have zeros instead of alpha O and
found quite a few. In your VBA editor, select the section of code and use the
Edit - Find and enter a zero and you will find them all.

Note that I think that Barbara's answer is the better solution. However,
personally I would modify the following so that I did not have to work out
the column number of CQ. It then becomes self documenting for the column Id
and easy to modify if required.

lastCol = Columns("CQ").Column
'Then use in following
For myCol = 1 To lastCol

--
Regards,

OssieMac