- Nov 22, 2002
Columns(E:E).EntireColumn.Autofit Range ("d3:d8") Selection.Cut Range("E3").Select Activesheet.paste
This code works, except for when it is used by my colleague in Vietnam, where it causes the runtime error '-2147417848(80010108)'
Method 'Paste'of object '-Worksheet' failed.
The code simply cuts a range and pastes it to another column. Also other macros wihich do similar operations work perfectly (I'm guessing that this rules out variations in separators is a at fault) Can anyone give a suggestion on how to get round this or even just what the runtime error is