Hi again,

I tried susan's way because it seemed the most straightforward, and inserted
a named range from A2 to A101 as "A2toA101".

I incorporated this fine, but when a row was inserted, the named rage
properties changed from =Sheet1!A2:A101 to =Sheet1!A3:A102 !!

I'll try the INDIRECT function if I can figure it out! Thanks.