View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Jump to "Defined name" range!

Try that from another sheet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Don Guillett" wrote in message
...
just like if it wasn't named

Sub gotomynamedcells()
Range("mynamedcell").Select
End Sub

--
Don Guillett
SalesAid Software

wrote in message
ps.com...
Hi,

I need help on how to jump to a "defined name" cell using vba. Please
help!! Lets say that a defined name cell is "COST" fo cell A10, how
could I write a code to select that cell based on the defined name ?
Thanks


Tim,