Selecting Active Cell before Text Import Routine

P

Paul

I have set up a routine to import a text file into Excel. I have macro button set up on the first worksheet, but I want the import to happen to a subsequent page. Does anyone know what VBA is required to select a new "active cell" or "active worksheet" for a macro within the same workbook? Thanks for your help....signed, cold in Detroit.
 
P

peterDavey

Paul, try this:

Worksheets("sheet2").Activate
ActiveSheet.Range("a5").Activate

peterDavey
(just right in Melbourne)

Paul said:
I have set up a routine to import a text file into Excel. I have macro
Click to expand...
button set up on the first worksheet, but I want the import to happen to a
subsequent page. Does anyone know what VBA is required to select a new
"active cell" or "active worksheet" for a macro within the same workbook?
Thanks for your help....signed, cold in Detroit.
 
Top