Question about VBA CODE not working good

hi guys,

do not know if there are VBA specialists on the board, but I pop the question:

since recently when I save a docu automatically, like 199-invoice I get:

blanc 199-invoice, instead of the same without the blanc position in front. Sorting the invoice at the back, since sort happens decending.

When I remove the blanc in front the sort happens correctly, but when I rename the invoice to 199-invoic (not altering the blanc position) all of a sudden the sort is ok as well.

Very strange.

In order to remove all macro's and codes to get a blanc document I use:

ActiveSheet.Copy
With ActiveSheet.UsedRange
.Copy
.PasteSpecial xlValues
.PasteSpecial xlFormats
End With

This happens before the save and my guess is that the problem lies there.


any ideas are welcome

thanks

jeff

hi Superfly,

will try that ASAP and post back here.

thanks

Jeff

well Superfly,

no difference, do not know what to do with it.

result just the same, when renaming it to whatever, the space in the first position is gone then.

but thanks


jeff

ok S

will check this

thanks

Jeff

ok Superfly,

you where right and it works. Thanks for your help, you saved my week....


Jeff