| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill blank cells with cells above data
Try this function:
Sub FillDown() Range("B2").Select Range(Selection, Selection.End(xlDown)).Select Range("B4:B1000").Select Selection.SpecialCells(xlCellTypeBlanks).Select Selection.FormulaR1C1 = "=R[-1]C" End Sub Note: B2 whould be the first cell in the column that contains data; adjust range to suit -- RyGuy "Pete" wrote: Glad to help - thanks for getting back. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank cells and Charting multiple data points | Charts and Charting in Excel | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
| FILL IN BLANK CELLS | Excel Discussion (Misc queries) | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Hybrid Mode
