Help - VB code required for inserting cells

hattster

Board Regular
Joined
Jan 27, 2005
Messages
78
Hi,
I have a spreadsheet that contains 5500 lines of data, I need to insert a blank row of cells every 27th line can anyone explain what i need to do to complete this other than inserting cells manually.
Cheers
Kev
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,915
Office Version
  1. 365
Platform
  1. Windows
Kev

Something like this perhaps?
Code:
Set rng = Range("A1")
While rng.Value <> ""
    rng.Offset(27).EntireRow.Insert
    Set rng = rng.Offset(28)
Wend
 

Watch MrExcel Video

Forum statistics

Threads
1,113,862
Messages
5,544,726
Members
410,630
Latest member
JFORTH97
Top