Use a range value in place of sheet name

J

John Wilson

Tried searching for this but I guess I'm using the wrong criteria (or just
having a brain fart).

I have a formula that gets a value from a particular sheet:
=Names!H35

What I want to do is substitute the sheet name for what's in a named range.
i'e. I have a sheet named "XXX"
I have a range named "LastSheet"
The value of "LastSheet" is "XXX"

How do I modify my original formula to use "LastSheet" to get whatever
is in H35 on Sheet "XXX" ?

Thanks,
John
 

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

using named range in VBA 10
Macro not working at year end 2
Sheet selection on Autoclose 2
Saving a range for later reference 0
use active cell to determine range 2
concatenate entries from a column into a cell by logical AND withanother column 2
Disable mouse clicks on a range of cells with validations 1
Automatically create new sheets... 1

Top