New
#1
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