How do you reference another worksheet without using its name

  • Thread starter dallen917 via OfficeKB.com
  • Start date
D

dallen917 via OfficeKB.com

The standard way to reference a cell on another worksheet within the same
file is Sheet2!A1. How can I create a reference that basically says A1 in
the next worksheet irregardless of its name (i.e., current worksheet + 1).
 

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

How do you reference another worksheet without using its name 1
VBA Coding Help for Beginner 0
Name of file opened, being viewed 2
Possible to refer to a sheet's object name ? 1
VBA for Dependents shortcut menu 0
Protected Sheet - Using Groups without a Macro 1
How do I use the text content of a cell as a worksheet reference? 9
Worksheet Names using Macros 5

Top