I have the following code that works perfectly on any 32 bit excel. However when someone tries it on a 64 bit version, they get an error message.
Does anyone know how to overcome this so that the code works on both machines?
Dim cel As Range
For Each cel In Selection
cel = Replace(cel, Chr(10), " ")