Problem: When I write a macro that acts on certain cells, the macro fails to
act properly if I insert rows above those cells that are normally acted upon.

I've tried to use both relative and absolute references, but when the row is
inserted the original cell reference in Visual Basic is not changed, but
remains the same.

Question: Is there a way to write a macro so that when row or column is
inserted the macro can go from any cell and find the correct cells to operate
for the macro?