Peter Davison
Active Member
- Joined
- Jun 4, 2020
- Messages
- 444
- Office Version
- 365
- Platform
- Windows
Hi
I have this code below for creating blocks based on two main cells E1 and E2 (e.g. E1 = 9 and E2 = 120) so the code will replicate 9 blocks of 120cm width plus the pre determined permanent height.
It then loops until it has completed the 9
What I want to change is -
Instead of it looking at E2 for the width I want it to start the first of the 9 (or whatever figure is in E1 looking at the width in Cell T4 and use each width in the cells T4 through to where the figure ends (in this case it would be AB4 (because it is 9 bays). This is because odd cell widths may be different.
I'm struggling to see what I would change in the code.
If anyone could help I would appreciate your time.
Another option if easier would be to ignore Cell E1 altogether and just use cells filled in from T4 onwards as the count
This is what it looks like on the sheet
I have this code below for creating blocks based on two main cells E1 and E2 (e.g. E1 = 9 and E2 = 120) so the code will replicate 9 blocks of 120cm width plus the pre determined permanent height.
It then loops until it has completed the 9
What I want to change is -
Instead of it looking at E2 for the width I want it to start the first of the 9 (or whatever figure is in E1 looking at the width in Cell T4 and use each width in the cells T4 through to where the figure ends (in this case it would be AB4 (because it is 9 bays). This is because odd cell widths may be different.
I'm struggling to see what I would change in the code.
If anyone could help I would appreciate your time.
VBA Code:
This is what it looks like on the sheet