Is there a way to name a range so that it doesn't automatically change when rows are added in between?
Ex: Range1 = 'Sheet1'!K5:K36
Add a row between rows 6&7 and now this automatically changes to
Range1 = 'Sheet1'!K5:K37
When i go into the named range sidebar, i've tried to change the formula to say:
Range1 = 'Sheet1'!$K$5:$K$36
but the $ go away immediately upon hitting ok