| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add a Row Every Fourth Row
After I delete all blank rowes I want to add a blank row every 5th row.
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add a Row Every Fourth Row
For how far
For i = LastRow to 1 Step -4 Rows(i).Insert Next i -- __________________________________ HTH Bob "daphoenix" wrote in message ... After I delete all blank rowes I want to add a blank row every 5th row. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add a Row Every Fourth Row
for like a 100 rows
"Bob Phillips" wrote: For how far For i = LastRow to 1 Step -4 Rows(i).Insert Next i -- __________________________________ HTH Bob "daphoenix" wrote in message ... After I delete all blank rowes I want to add a blank row every 5th row. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add a Row Every Fourth Row
Replace LastRow with 100 then.
-- __________________________________ HTH Bob "daphoenix" wrote in message ... for like a 100 rows "Bob Phillips" wrote: For how far For i = LastRow to 1 Step -4 Rows(i).Insert Next i -- __________________________________ HTH Bob "daphoenix" wrote in message ... After I delete all blank rowes I want to add a blank row every 5th row. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct Fourth Array | Excel Worksheet Functions | |||
| how to fourth root a number on excel | Excel Worksheet Functions | |||
| How do I eliminate every fourth row of data in a large file? | Excel Discussion (Misc queries) | |||
| MARK EVERY FOURTH ROW | Excel Worksheet Functions | |||
| Taking data from 3 columns to make the fourth. | Excel Worksheet Functions | |||
Hybrid Mode
