Goto a named range using the contents of the active cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a VBA macro that will allow me to use the cell contents of the current
active cell to select a predefined range that exists somewhere in the active
worksheet.

For example, cell a1 includes the text 'ABC'. There is a range in the
worksheet named 'ABC'. I need to select this range using the contents in
cell a1.

Thanks
 
This should be what you need!
Application.Goto Reference:=Range("A1").Value

Regards,
Simo
 

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

i = row number of last occurance of duplicate string Column A 4
macro to select range from active cell range name string 2
clear all sheets code 4
Find value of active cell in other visible worksheets 8
Excel VBA help: Text file formatting 19
Macro to combine worksheets 10
Find the correct sheet then find a value on that sheet 8
copy a range from active cell 6

Back
Top