Hi
I'm trying to start at cell A5
Insert 5 blank rows
Then count down 15 rows to cell A20
Insert another 5 rows
Then count another 15 rows so at cell A40 insert another 5 blank rows
Loop the same as above until the last row.
Hi
I'm trying to start at cell A5
Insert 5 blank rows
Then count down 15 rows to cell A20
Insert another 5 rows
Then count another 15 rows so at cell A40 insert another 5 blank rows
Loop the same as above until the last row.
This seems to work
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks for the help
It works fine when there are no blank cells in column A
The problem is in column A I get a blank cell every 15 rows (so I need to insert 5 blank rows whenever cell in column A is blank
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks