Replacing the blank cell by value in VBA

jayarampandian · #1 (**permalink**) 10-13-05, 07:08

DavidCoutts · #2 (**permalink**) 10-14-05, 06:31

like this

Code:

Sub TestIt()
    Range("A1").Replace "", "This Value"
    
End Sub
' or

Sub TestIt2()
    Range("A1:A10").SpecialCells(xlCellTypeBlanks).Value = "This Value"
End Sub

I think that is what you mean anyway

All the best
Dave

jayarampandian · #3 (**permalink**) 10-25-05, 02:02

Hi Dave,
yah I got it correctly.
thanks for your valuable infn.
I want to replace the blank cells with the values that are occured most times
in the given range with out using any loop.
Can you post as soon as possible if you knows..

bye..

With Regards,
S.Jayaram

Internet Services

Web Development

Digital Marketing

Consumer Tech