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 20
use active cell to determine range 2
Sheet selection on Autoclose 2
Disable mouse clicks on a range of cells with validations 1
refer to range in another sheet 5
Create new sheets based off Data sheet, and template sheet 2
Conditional sum in a named range 8
Can I use a named range in SUMPRODUCT? 2

Top