Hi All,
I just found this site and this code that Mikeerickson posted does what I wish on a spreadsheet.
With Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row)
On Error Resume Next
.SpecialCells(xlCellTypeBlanks).FormulaR1C1 = "=R[-1]C"
On Error Goto 0
.Value = .Value
End With
I wish to go a step further and looking for assistance.
The cells that were blank that were filled in from the cell above, "How do I color and Bold the filled in cells only"?
So, when I look at the column that was filled in where the blanks were, I can check to make sure everyting is in order!
Thanks
James Niven