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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select Text to End of Footnote 9
VBA for Dependents shortcut menu 0
Combine 2 columns in a dynamic range into one 7
How do I set focus (and select text) on a text box on a modeless userform? 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Adding custom menus to existing excel application 0
Select Previously Selected worksheet (and/or select previouslyselected workbook) 5

Top