"return to..." function
I have a worksheet with a lot of calculated data. I keep the data for the
calculated constants in another area of the worksheet. I have named those areas so I can hyperlink to them when I want to check anything there. However, I can't "easily" get back to where I started from. I am trying to program a button or macro I can use on the spreadsheet that will allow me to return to the point on the worksheet from which I left. I can easily do it by pressing "F5" and then return-- but that is a pain compared to a keyboard macro or a button. When I used the macro recorder it recorded the exact cell I left from the first time. If I cn just program it to activate the "F5" key and then the return key I get pretty much what I want. How do I go about this? |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com