Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
NamedRange - Variable Sheet
Is there a way to set a named range, based on the active sheet?
Example: Range1 =LOOKUP(2,1/('Sheet1'!$B$1:$B$5000<""),ROW('Sheet1'!$B$1:$B$5 000)) I want to be able to set this named ranged, based on the sheet I am in. If on sheet 2 it would set the range as: Range1 =LOOKUP(2,1/('Sheet2'!$B$1:$B$5000<""),ROW('Sheet2'!$B$1:$B$5 000)) etc... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Add NamedRange Controls to Worksheets? | Excel Worksheet Functions | |||
Unhide sheet based on NamedRange? | Excel Programming | |||
Addressing cells in a NamedRange | Excel Programming | |||
Cell Reference within NamedRange | Excel Programming | |||
sum (column 2 of namedrange) | Excel Programming |