I have a named range – first_Range. I have two buttons –
Abbreviate - restores the named range to B3:C7
Expand – expands the range to include B3:C11
Now recording macro and doing this doesn’t solves the problem as I am having issues in the vba code.
Is there a VBA code that does that – resizing the range according to the button pressed…
For example, ihis one is not working….
Count, 1).Resize.Name = "first_Range"