NeedsHelp2
New Member
- Joined
- Nov 20, 2005
- Messages
- 22
I'm importing data from a CSV file. The columns that it's supposed to pick up are A:CL. However I found a problem in that columns BF:CL are not being imported. I suspect that this is because AZ:BE are empty. Is there away to overcome this?
Code:
Cells(1, 1).CurrentRegion.Copy Destination:=SourceBook.Sheets("Data").Range("A1:CL65536").End(xlUp).Offset(0, 0)