Simple question - Named Range in Macro
 

How do I create a macro to go to a sheet and a certain cell that i
named?

Range ("Name").Select was what i thought, but that does not work.

thanks
Ca

--
Message posted from http://www.ExcelForum.com

Simple question - Named Range in Macro
 

Application.Goto "namedrange"

Range("name").select only works when target range is on the active
worksheet.

Stephen Rasey
Houston
http://wiserways.com
http://excelsig.org

"wammer " wrote in message
...
How do I create a macro to go to a sheet and a certain cell that is
named?

Range ("Name").Select was what i thought, but that does not work.

thanks
Cam


---
Message posted from http://www.ExcelForum.com/