excel vba replace

[SamT]

I would just save the book as an *.xlsb and see what the size was

I can never get Quote marks right in a String containing Quote marks so I use

Const DQ as String = """
'
'
Selection.Replace What:=DQ & "=", ''''''''''''''

[kds]

that's the next project since i'm very new at vba but thanks anyways

[kds]

thank you four your help, however i don't seem to get it quit right...