Chewyhairball
Active Member
- Joined
- Nov 30, 2017
- Messages
- 312
- Office Version
- 365
- Platform
- Windows
Hi
Is there a was to change a named range according to a number in a cell.
I have Range1 in name manager going from A2:A11
Can I define how many rows are in a range using the value in D4.
So then if i type 20 in cell D4 the range changes to A2:A21 etc...
Is there a was to change a named range according to a number in a cell.
I have Range1 in name manager going from A2:A11
Can I define how many rows are in a range using the value in D4.
So then if i type 20 in cell D4 the range changes to A2:A21 etc...