View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default 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