Row is moving...

[ChrisXcel]

I ran a macro just now and there were unexpected results.
This is because I was relying on copying data from row 101 to row 20.

But something had changed in the worksheet when I was cutting/pasting, inserting, deleting rows etc.
and row 101 was now in row 90 something!

I just found out why the row had been moving.
I was using this command ActiveCell.EntireRow.Delete instead of
ActiveCell.EntireRow.Clear

Even so, what can I do to permanently lock in the data in row 101 so that it was always be there? Even if I delete rows?


Thanks!

[FDibbins]

What is in row 101? if it is data, then if you delete rows above, it will move up

[ChrisXcel]

What is in row 101? if it is data, then if you delete rows above, it will move up

There are mostly simple formulas like =D101-C101 etc.
I hope to stay away from deleting rows, but if it is done in the future, is there some way of keeping the row where it is? Perhaps I should name the row as a range? Then if it moves, the subs that make reference to it, will be OK?

[FDibbins]

giving it a range name is a good idea, try it and see if that solves your problem?