Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add in specific cells
Dear volunteers,
I got following script from the discussion group months ago to separate groups of data with two empty rows base on cells in column A. Now I would like to add text and formula in column D and E (in every first empty row) at bottom of each groups, any ideahow can I do that? Dim lngRow As Long For lngRow = Cells(Rows.Count, 2).End(xlUp).Row To 2 Step -1 If Range("A" & lngRow) < Range("A" & lngRow - 1) Then Rows(lngRow).EntireRow.Resize(2).Insert End If Next Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import data to specific cells for a specific row | Excel Discussion (Misc queries) | |||
Getting specific data into specific cells? | Excel Discussion (Misc queries) | |||
Form a circle (ie. color specific cells) given specific radius | Excel Programming | |||
macro to select cells containing specific text and delete all cells but these | Excel Programming | |||
Delete specific cells contents in a row with some locked cells in the same row | Excel Programming |