Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Addressing cells in a NamedRange
To make a long story short, you can't please all the people all the time. I
have written a report that analyzes weekly data and puts the results onto a report-like sheet. I have written my code directly to the display cells in the usual manner. For the 4th time now, they have decided to re-arrange the look and format of my report sheet. Naturally, they want me to re-write the code again to place the results where they want them. I also know that this will never end, like the wife moving around the furniture just to see how it would look and fit. And now for the question. I could take each section of the report and make them Named Ranges and have the code write to the range names, wherever they may be relocated on the sheet. How would I refer code to a specific cell location within that range? For example I now put data into "H9" by writing Range("H9").Value = dataA + dataB. If "H9" is within Named Range "ProfitMargin" and is 4 cells down and 3 cells right of the upper left corner of the range, how would I code to that range position. Any help would be appreciated while I still have some hair and sense of humor. Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Add NamedRange Controls to Worksheets? | Excel Worksheet Functions | |||
absolute addressing and inserting new cells | Excel Discussion (Misc queries) | |||
Addressing cells on inactive sheets | Excel Discussion (Misc queries) | |||
Addressing cells without selecting | Excel Programming | |||
sum (column 2 of namedrange) | Excel Programming |