Greetings Programmers,

Would there happen be a way to update all ranges or references in
modules when one or more rows are added or deleted?

Reason I ask is that the 'heading' row on a sheet starts on row 12,
and users may wish to add or remove rows above this heading line.
Examples of code with set ranges a

Set ActivityDate = ActiveSheet.Range("C11")
and
ActiveSheet.Cells(lastcolumn + 1).Offset(12, 0).Select

....so references such as C11 and (12,0) would be affected.

Just curious.
Thanks,
Arnold