Selecting Active Cell before Text Import Routine
 

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.

Selecting Active Cell before Text Import Routine
 

Paul, try this:

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

peterDavey
(just right in Melbourne)

"Paul" wrote in message
...
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.

Selecting Active Cell before Text Import Routine
 

Peter- it didn't change over to the next sheet....any other suggestions?