Move to a cell referenced from the current cell.
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 -- Message posted from http://www.ExcelForum.com |
Move to a cell referenced from the current cell.
Press Ctrl-[
|
Move to a cell referenced from the current cell.
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) "timspin " wrote in message ... 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, I dont want to have to spend ages going to my main data table, searching for the right place and editing. I would like to select a cell in a worksheet, and for a macro (when I hit Shift F1 say) to place the cursor in the location that was referenced from that cell. This would be really useful, any ideas and help greatly appreciated. Best regards Tim Gee --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 10:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com