Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
replace blanks with values above
Hi,
I know this topic has already been posted and since I don't know VB excel programming, I used the code from a previous post to achieve what i want. I need to search for blank values in a range and replace them with the value above. My code: Sub BlankRepeats() For Each cell In Range("A2:A35") If cell.Value = "" Then cell.Value = cell.Offset(-1, 0).Value End If Next cell End Sub It iterates through the entire range and doesnt seem to pick up any values as though all are blanks and hence no changes are made. Meanwhile the column A has text values in many rows. Will appreciate some help. Thanks Susan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace values in shaded cells with blanks | Excel Discussion (Misc queries) | |||
Search and replace blanks | Excel Programming | |||
replace blanks using formula | Excel Worksheet Functions | |||
Need to get rid of 0's and replace with Blanks | Excel Worksheet Functions | |||
replace "#DIV/0!" error with blanks | Excel Worksheet Functions |