View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stephen Rasey[_2_] Stephen Rasey[_2_] is offline
external usenet poster
 
Posts: 41
Default 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/