Resizing a range

**druid98** · 09-14-2011, 09:01 PM

I recorded a macro using the RANGE MANAGER function to reset the size of a range by editting the range and using <END><DOWN> in the hope it would automatically resize. I got this:

Please Login or Register  to view this content.

Instead of specifying the range bottom as R1621C8 how can I incorporate the <END><DOWN> to resize the range dynamically?

**Leith Ross** · 09-14-2011, 10:49 PM

Hello druid98,

Are you trying to make a Named Range dynamic?

**druid98** · 09-15-2011, 07:07 PM

Yes, that is exactly what I'm trying to do.

**druid98** · 09-17-2011, 02:03 AM

OK. I found one possible solution with this code, which deletes the range then re-establishes it:

Please Login or Register  to view this content.

I get that RefersToR1C1:="=Attendance!R4C23 is the starting point of the range, but what does the ("W4") refer to in :R" & Range("W4").End(xlDown).Row & "C23:C28" (which I presume means to go to the bottom of the range and then across 5 columns)? This looks very promising, but so far it hasn't worked for me and I'm not sure I'm phrasing it right.