Selecting Active Cell before Text Import Routine

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top