Hi, I'm trying to create an import macro for my data aquisitions. The code I'm using is:
Range("A1:PP1").Select
Selection.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, Lookat:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False).Activate
SaveColNdx = ActiveCell.Column
I would like to import around five data sets into one sheet and this code works great once I've imported the data once.
The trouble I have is that this code doesn't work when the sheet is completly empty. How do I fix this?
Range("A1:PP1").Select
Selection.Find(What:="", After:=ActiveCell, LookIn:=xlFormulas, Lookat:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False).Activate
SaveColNdx = ActiveCell.Column
I would like to import around five data sets into one sheet and this code works great once I've imported the data once.
The trouble I have is that this code doesn't work when the sheet is completly empty. How do I fix this?