tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I have a shape Called "View1"
all i want is a macro that will increase or reduce its size according to the data in the column it surrounds
So the shape is placed around data in column C (the width if fine,
My rows are all set at height of 15
Data starts in Row 16
so i want a macro that checks how many rows in coulmn C16 down have data in them and increase the shape by that many rows or reduce it
so lets say shapes default height is 40, then if each row increases the size by 15 then it 40 + 15*number of rows
please help if you can
Thanks
Tony
I have a shape Called "View1"
all i want is a macro that will increase or reduce its size according to the data in the column it surrounds
So the shape is placed around data in column C (the width if fine,
My rows are all set at height of 15
Data starts in Row 16
so i want a macro that checks how many rows in coulmn C16 down have data in them and increase the shape by that many rows or reduce it
so lets say shapes default height is 40, then if each row increases the size by 15 then it 40 + 15*number of rows
please help if you can
Thanks
Tony