I have created a macro and i has been running fine but now i am getting an error that says "cannot shift objects off sheet". when i go to debug the error is occurring at
.Refresh BackgroudQuery:=False
The macro is basically importing a file, sorting it, deleting some rows and then moving it to a new sheet.
Any thoughts?
.Refresh BackgroudQuery:=False
The macro is basically importing a file, sorting it, deleting some rows and then moving it to a new sheet.
Any thoughts?