When I first open my workbook and run a macro with the following syntax I get an error.
"Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats"
However, if I reset the macro after the error the macro runs fine. I am running Excel 2002.
Any advice??
Thanks,
Bob
"Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats"
However, if I reset the macro after the error the macro runs fine. I am running Excel 2002.
Any advice??
Thanks,
Bob