Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
add row
Hello,
I have a spreadsheet that has 250 rows, I have to add a blank row after every fifth row, is there a formula to apply to my spreadsheet. Manually is quite a hassle. Thank you, all -- smile |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
add row
Sub addrowevery5()
counter = 6 Do Until Cells(counter, "a") = "" Rows(counter).Insert counter = counter + 6 Loop End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "israel" wrote in message ... Hello, I have a spreadsheet that has 250 rows, I have to add a blank row after every fifth row, is there a formula to apply to my spreadsheet. Manually is quite a hassle. Thank you, all -- smile |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
add row
Sorry to bother, can you be more specific how to execute the formula, I'm a
bit confused. Thank you again -- smile "Don Guillett" wrote: Sub addrowevery5() counter = 6 Do Until Cells(counter, "a") = "" Rows(counter).Insert counter = counter + 6 Loop End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "israel" wrote in message ... Hello, I have a spreadsheet that has 250 rows, I have to add a blank row after every fifth row, is there a formula to apply to my spreadsheet. Manually is quite a hassle. Thank you, all -- smile |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|