Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Named Ranges
Hello NG,
I'e been using Excel for a while but I'm new to Named Ranges. I have a column of hyperlinks, on a master page, to cells I've named on indiuidual pages. example on the sheet for Smith in cell A2 I call it Smith_Week_1 and again on Smith in Cell A18 I call it Smith_Week_2. and so forth down the page for about 20 different cells. I do this for 9 employees. Depending on where the worksheet was last closed the named cell will be in the middle of the page or at the top or at the bottom. Is there a way to always make the named cell be in the top left cornor? Thanks for any help -- James |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Programming | |||
named ranges - changing ranges with month selected | Excel Programming |