wheres my type mismatched??

I am finding a replacing with the following code:

Please Login or Register  to view this content.

I am getting the type mismatch error, no matter what I do. im sure it something soooo simple, but its beyond me lol.

thanks for your help with this dumb minor, annoying problem

thanks

#DIV/0!

but I have also tried entering a number it does the same thing. I had it working at one time, then of course tried to get fancy with it and cant get back to where I ended ha. pretty much I want to place a 0 where my formula cant divide by 0, over a span of A:AH

Sub test()

Please Login or Register  to view this content.

3
and it works for that one cell. But I am wanting to apply this for every cell in the column, it doesn't like it when I try to force to by selecting the whole column

This is exactly what I started out with:

Please Login or Register  to view this content.

and it works for that one cell. But I am wanting to apply this for every cell in the column, it doesn't like it when I try to force to by selecting the whole column

thanks JosephP, that will work for me.