Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop fill in the blanks (down) at specific row
Works fine. Just need to add command to stop at specific row.
Starts at 25, lets say stop specifically at row 1000. Sub FillInTheBlanks_1() Dim Area As Range, LastRow As Long On Error Resume Next LastRow = Cells(Rows.Count, "C").End(xlUp).Row For Each Area In Intersect(Rows("25:" & LastRow), Range("C25"). _ Resize(LastRow).SpecialCells(xlCellTypeBlanks)).Ar eas Area.Value = Area(1).Offset(-1).Value Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill in the blanks! | Excel Programming | |||
Fill in the blanks! | Excel Programming | |||
Fill in the blanks!! | Excel Programming | |||
Fill in the blanks | Excel Programming | |||
Fill in the blanks | Excel Programming |