Ironman
Well-known Member
- Joined
- Jan 31, 2004
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
Hi
I have a sheet containing data from A2 to G6210.
I need to insert a blank, shaded row between every row up to and including Col G (all of which contain data, which must not be amended).
Specifically, I would be very grateful for a module that I can run that will insert blank rows every other row, starting A3:A6211 inclusive, with the cells filled #EEE7D7 up to and including Col G.
i.e.
A3:G3 filled #EEE7D7
A5:G5 filled #EEE7D7
A7:G7 filled #EEE7D7
etc. etc.
A6211:G6211 filled #EEE7D7
Many thanks!
I have a sheet containing data from A2 to G6210.
I need to insert a blank, shaded row between every row up to and including Col G (all of which contain data, which must not be amended).
Specifically, I would be very grateful for a module that I can run that will insert blank rows every other row, starting A3:A6211 inclusive, with the cells filled #EEE7D7 up to and including Col G.
i.e.
A3:G3 filled #EEE7D7
A5:G5 filled #EEE7D7
A7:G7 filled #EEE7D7
etc. etc.
A6211:G6211 filled #EEE7D7
Many thanks!