Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Goto Sheet Name
dim anyS as string
anyS = activesheet.name workbooks("mno.xls").activate sheets(anyS).select workbooks("xyz.xls").activate sheets(anyS).select Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Kash" wrote in message ... I have 3 workbooks (abc.xls, mno.xls, xyz.xls) with same sheet name. How to write a macro to go to the same sheet name which is active on abc.xls in the remaining 2 workbooks? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goto last row of the sheet | Excel Worksheet Functions | |||
Goto in a sheet | Excel Programming | |||
Goto first or last sheet | Excel Programming | |||
Goto Sheet based on Cell Value | Excel Programming | |||
GOTO another sheet | Excel Programming |