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.