| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unknown address change
Excel 2002, WinXP
I have a simple 3 line code: MsgBox j.Address 'A4, correct j.Offset(, 3).Formula = "=E" & j.Row & "/C" & j.Row MsgBox j.Address 'D4 "j" is a single cell range, A4. As you can see, "j" is set to D4 after the formula is inserted into D4. Why? I expected "j" to stay A4. Thanks for your help. Otto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change of cells address | Excel Discussion (Misc queries) | |||
| How Can I Globally change Address of Hyperlinks? | Excel Discussion (Misc queries) | |||
| My hyperlink address change? | New Users to Excel | |||
| How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
| Hyperlink change address | Excel Discussion (Misc queries) | |||
Threaded Mode
