Thread: How to build a forward/back range finder
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How to build a forward/back range finder
Not only possible, but already done by Jan Karel Pieterse.

http://www.jkp-ads.com/Download.htm
look for: GoBack.Zip




John Wirt wrote:

Is it possible to build a "stack" that remembers the last 5 (or whatever)
sheets and ranges, so that with key strokes the user can switct back to the
previous sheet and selected range on that sheet, the sheet and selected
range before that, and so on for five steps or so backward. Plus, once in
the stack the user could reverse course and go to the Next sheet/selected
range.

John Wirt

--

Dave Peterson
Reply With QuoteReply With Quote