I notice something in user defined name ranges.
I inherited an Excel file with close to 30 name ranges. When I ran one of
my routines to extract all the names and ranges of the user defined name
ranges, I noticed they were all in absolute format, for example:
Sheet1!$C$70:$C$193. Normally I thought that means the references do not
The reason for my concern was that there are two adjacent ranges separated
by three rows, so as I expand downward from the first range, as in inserting
new rows, the existing rows would continue to move down, but the referenced
range would stay static, and would still stay the same, or so I thought, but
apparently the user defined name ranges also changes as rows were inserted,
thus, the named range stays intact. I was not aware this was possible when
absolute cell reference is used with the $ sign like above? I am perplex.
Please share your thoughts, thanks in advance.