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?