ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to build a forward/back range finder (https://www.excelbanter.com/excel-programming/335376-how-build-forward-back-range-finder.html)

John Wirt[_10_]

How to build a forward/back range finder
 
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

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


All times are GMT +1. The time now is 02:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com