Move to a cell referenced from the current cell.

  • Thread starter Thread starter timspin
  • Start date Start date
T

timspin

Hi all,

Can anyone help me.
I have a huge table, full of data
To see the data I use 5 different worksheets referencing this table.
When Im in one of these worksheets, I see some data I want to change,
dont want to have to spend ages going to my main data table, searchin
for the right place and editing. I would like to select a cell in
worksheet, and for a macro (when I hit Shift F1 say) to place th
cursor in the location that was referenced from that cell.

This would be really useful, any ideas and help greatly appreciated.
Best regards
Tim Ge
 
Tim,

Put this code in a macro and use that

If ActiveCell.HasFormula Then
Application.Goto Reference:=Range(Mid(ActiveCell.Formula, 2, 99))
End If

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
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

Referencing Inactive Workbook Cells 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel Shortcut to go to the page/document referenced within a cell in excel 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
program a cell in excell to reference a cell below a referenced ce 2
cell already referenced 2
Ron de Bruin - Merge cells from all worksheets 0
How to use OFFSET in VBA 1

Back
Top