UsedRange

[LB79]

Hello,

I'm having a problem wording some VBA.
I want to highlight the used range of a sheet, then replace all blank cells with 0.

I tried using the below code but it says Object Required.

Sub MyMacro()
UsedRange.Select
Selection.Replace What:="", Replacement:="0", LookAt:=xlPart, SearchOrder:=xlByRows
Selection.FormulaR1C1 = "1"
End Sub

Thanks for any advice.

[zbor]

Something like this?

Please Login or Register  to view this content.

Woo hoo... my first macro... ok... not mine... Someone's else but edited and adopted