Aloha all:
Did something just change in the Excel environment or in the VBA environment several days ago? I have a data cleaning macro that I've been using for years, all of a sudden it hangs up on a basic Paste line.
When the macro is launched, it copies some cells on the same row as the active cell, moves up a few rows based on criteria in column B, and pastes the copied cells. The line of code is
ActiveSheet.Paste Destination:=Cells(ActiveCell.Row, ColNum)
where ColNum has been set a little earlier in the macro. Now I get a runtime error message, "Paste method of Worksheet class failed" but the data IS ACTUALLY pasted in the right place at that point. Why could it be erroring AFTER pasting? Why is it erroring at all? Again, I have been using this macro for years and was using it for a couple hours on Monday 5/20 (I think) when at about 3 PM HI time it started failing at this line.
All comments and help are appreciated.
Mahalo,
John Jacobson
Bookmarks