Adding blank spaced to unused cells

[wmtsub]

Please, can anyone tell me why I can not get this to work?

ActiveSheet.Range("A2:Z50").Select
ActiveSheet.UsedRange.SpecialCells(xlBlanks).Value = " "

 

[Fluff]

What exactly is not working?

 

[Joe4]

Maybe this?

ActiveSheet.Range("A2:Z50").SpecialCells(xlBlanks).Value = " "

But a better question may be, why do you need to do this?
I have a feeling that this part of something bigger, and there may be other better ways to accomplish your ultimate goal.

 

[wmtsub]

I am not sure why but that does not work either it just highlights the line of code, just like the first one.
Might it hav esomething to do wiothj conditional formating on the page?

 

[Joe4]

Try posting all of your code.

And can you answer the question I asked?

But a better question may be, why do you need to do this?
I have a feeling that this part of something bigger, and there may be other better ways to accomplish your ultimate goal.

 

[Fluff]

Do you get any error messages?

 

[wmtsub]

no, it runs but does nothing

 

[Fluff]

As requested by Joe4, can you supply the complete code & explain what you are trying to do?