View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chemist chemist is offline
external usenet poster
 
Posts: 10
Default "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?