- Nov 20, 2005
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?
Cells(1, 1).CurrentRegion.Copy Destination:=SourceBook.Sheets("Data").Range("A1:CL65536").End(xlUp).Offset(0, 0)