About Us

Don Guillett

OK. application.goto

--
Don Guillett
SalesAid Software

"Bob Phillips" wrote in message
...
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,

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Message "user defined type not defined"	LEELK01	Excel Discussion (Misc queries)	2	August 14th 09 07:31 AM
"User-defined type not defined" error when trying to send e-mail	SupperDuck	Excel Programming	9	August 2nd 06 07:36 AM
use variable in Workbooks("book1").Worksheets("sheet1").Range("a1"	Luc[_3_]	Excel Programming	2	September 28th 05 08:37 PM
"Application-defined or object-defined error" while printing excel report	chemburkar	Excel Programming	0	February 2nd 04 08:33 PM