How to build a forward/back range finder

  • Thread starter Thread starter John Wirt
  • Start date Start date
J

John Wirt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error Message - Macro to Unlink MS Queries from Workbook 0
Name the range AFTER copied to new sheet 6
building a range for SetSourceData 7
copy a range from active cell 6
Creating a stack to push/pull ranges 14
Post my named ranges in column A 10
Creating range name based on cell value. 6
Set a Range to a variable 15

Back
Top