| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting Active Cell before Text Import Routine
Peter- it didn't change over to the next sheet....any other suggestions?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting all the active cells in a named column. | Excel Worksheet Functions | |||
| Selecting cells on active row | Excel Discussion (Misc queries) | |||
| Selecting/Highlighting active cells | Excel Discussion (Misc queries) | |||
| Selecting active area of sheet | Excel Discussion (Misc queries) | |||
| programatically selecting columns to import text into | Excel Discussion (Misc queries) | |||
Linear Mode
