| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
relative addressing in code
Given a properly formatted date and code of CurMonth = Month([A400]) how can
I move the cell with date(A400) and have code follow change? I've tried many things -- none work. What am I missing? Thanks, Kim |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
relative addressing in code
Name the cell (InsertNameDefine ...), and use that name
CurMonth = Month(Range("named_cell")) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Kim" wrote in message ... Given a properly formatted date and code of CurMonth = Month([A400]) how can I move the cell with date(A400) and have code follow change? I've tried many things -- none work. What am I missing? Thanks, Kim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative Addressing not working | Excel Worksheet Functions | |||
| what is the difference between relative and absolute addressing | Excel Discussion (Misc queries) | |||
| Relative addressing | Excel Worksheet Functions | |||
| Relative Addressing | Excel Discussion (Misc queries) | |||
| Modifying Relative Addressing | Excel Programming | |||
Linear Mode
