Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding number of rows
Hello,
I'm trying to create a report using VBA, and I think I've got it all down except for one step, and that is to add 35 blank lines between each of 130 numbers. This is pulling data from lots of places with this being step # 2, and when this part is done everything else shouldn't be a problem. If it's relevant step 1 in this process pulls a $ value from two cells on 65 worksheets into a column. Below is what I've got now from an earlier process that I tried to modify and it doesn't work. Any help would be greatly appreciated. Sub SherrysUpload2() For i = Cells(Rows.Count, "a").End(xlUp).Row To 2 Step -1 If Cells(i, 1).Value < Cells(i - 1, 1).Value Then Rows(35).Insert End If Next End Sub -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding rows based on no of rows specified from a given position | Excel Worksheet Functions | |||
Adding a number to a cell that already has a number. | Excel Discussion (Misc queries) | |||
Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
Sequential number - adding and deleting rows | Excel Discussion (Misc queries) |