Hi Guys-
Hoping someone may be able to shed some light on this.
I have a macro I've created but I want the macro to start by deleting the information and getting rid of the subtotals that we're there previously.
The current code I have is this:
With Sheets("ActivantSKUAdjustments").Columns("A:J")
.Delete Shift:=xlToLeft
.RemoveSubtotal
End With
The problem is that if for some reason that subtotal isn't there, I get the error message:
Run time error 424 Object Required. I want the macro to delete the subtotals if they are there but not do anything if they aren't. Any advice?
Bookmarks