Excel VBA simple one *RESOLVED*

[phinds]

in an Excel VBA macro, I have the statement

Range("D44").Value = n2

which works fine until I add a row, at which time the "D44" reference REMAINS "D44" even though the cell I'm targeting has moved down one row.

So, my question is, is there some way to tie VBA code to cells in a way that lets them track the cells as they do when they are referenced by formulas? That is, if a FORUMLA used "D44" and I added a row, the formula would then use "D45", which is what I want my VBA to do.

Thanks for any help.

[opus]

One way could be to assign to targetcell a name and use this name to call it instead of "D44"

[phinds]

JUST what I was looking for --- thanks opus

[opus]

Great, I could help somebody today, that make this "working"day a success.