populating blank cells with previous valid value

**redhead** · 03-15-2011, 07:26 PM

Hi...pls forgive me if I seem green, but this is a first

I have a column containing data that I want to duplicate in another column, except instead of transfering blank cells, I want to populate it with the previous valid value eg if A3 is blank, and A2 is blank, then I want B3 to be populated with the value in A1

**davesexcel** · 03-15-2011, 07:37 PM

Hi redHead,
It may be easier to just fill in the blank cells in Column A
Try this,

Sub FillBlanks()
    
    Columns("A:A").SpecialCells(xlCellTypeBlanks) = "=R[-1]C"
End Sub

Or you could copy the column to a new location, then run the code for the new column

Thread: populating blank cells with previous valid value

Thread Tools

Display

populating blank cells with previous valid value

Re: populating blank cells with previous valid value

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions