| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a value in a column over blank cells
I would like to copy values in Column A over blank cells until the next
available value. I would like this to run in a loop until a blank row is reached. I would be grateful if you could provide me a macro that can do this. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200605/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy a value in a column over blank cells
Don't loop:
Sub FillColumnA() On Error GoTo NoBlanks With Columns("A:A") .SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C" .Copy .PasteSpecial Paste:=xlPasteValues End With Application.CutCopyMode = False NoBlanks: End Sub HTH, Bernie MS Excel MVP "mohd21uk via OfficeKB.com" <u20517@uwe wrote in message news:5ffe29df54ebe@uwe... I would like to copy values in Column A over blank cells until the next available value. I would like this to run in a loop until a blank row is reached. I would be grateful if you could provide me a macro that can do this. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200605/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy cells become blank | New Users to Excel | |||
| How to copy info into blank cells within a column (going up the co | Excel Discussion (Misc queries) | |||
| how to copy blank cells | Excel Discussion (Misc queries) | |||
| Copy a formula into a blank column only to the last data row | Excel Worksheet Functions | |||
| HOW DO I COPY THE LAST NON BLANK CELL IN A COLUMN | Excel Worksheet Functions | |||
Linear Mode
