Jump to "Defined name" range!

  • Thread starter Thread starter timduongt
  • Start date Start date
T

timduongt

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,
 
application.Goto range("COST")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
just like if it wasn't named

Sub gotomynamedcells()
Range("mynamedcell").Select
End Sub
 
Try that from another sheet.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Bob, how would you access a named ranget from another workbook?

Die_Another_Day
 
Don't think you can in one move, need to select the other workbook, the
Goto.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
I screwed around and got this to work:
Application.Goto Workbooks("Book1.xls").Sheets(1).Range("Test")

Die_Another_Day
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Vba Help with Information Extraction 0
using defined name in UDF 7
random range of cells via cell names 3
range name define on non active(focused) sheet 10
make use of cell defined data validation in vba 1
user defined function which increase consecutively while passingbelow cells 12

Back
Top