Thread: Insert blank row after every 11th row.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Insert blank row after every 11th row.
Post it

--
Don Guillett
SalesAid Software

"Captain Snuggles" wrote in message
ups.com...
I've found some vb code that kind of does what I need, but every time
I tweak the code to have it insert the blank row after each 11th row
it doesn't work. Any ideas?

Row 1 | Column Header
Row 2 | Value 1
Row 3 | Value 2
Row 4 | Value 3
Row 5 | Value 4
Row 6 | Value 5
Row 7 | Value 6
Row 8 | Value 7
Row 9 | Value 8
Row 10 | Value 9
Row 11 | Value 10
Row 12 | Value 11
Row 12 | BLANK ROW
Row 13 | Value 12...and so on and so forth.



Reply With QuoteReply With Quote