MBUser,
This is a "classical" example of a situation where you MUST begin to use (and preferably ALWAYS use) "RANGE NAMES".
Internally, Excel maintains a "link" between "Range Names" and the cell(s) to which they are assigned. Therefore, whenever rows or columns are inserted, this does NOT affect any VBA code which uses Ranges Names.
The EASY way to Assign Range Names:
1) Highlight the cell or range of cells.
2) Use <Control> <F3> - i.e. hold down the <Control> key and hit the <F3> key.
3) Type the name you wish to use.
4) Hit <Enter>
Reminder: Do NOT use any names which "conflict" with cell addresses or numbers. For example, do NOT use "A1" - instead use "_A1", do NOT use "1" - instead use "_1".
If you have any misunderstanding over this, please enquire either here, or email me directly.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca