on error

[wmtsub]

I am using this script in a macro and it runs fine but if it runs a second time and nothing has changed it geves me an error. How can I protect against that?



' pad Spaces
ActiveSheet.UsedRange.SpecialCells(xlBlanks).Value = " "
<strike></strike>

 

[Rick Rothstein]

I am using this script in a macro and it runs fine but if it runs a second time and nothing has changed it geves me an error. How can I protect against that?



' pad Spaces
On Error Resume Next
ActiveSheet.UsedRange.SpecialCells(xlBlanks).Value = " "
On Error GoTo 0
<strike></strike>

Try adding what I show in red above.

 

[wmtsub]

thank you