The following causes a "Error 1004 Method 'Range' of Object '_Worksheet' failed.
I'm working in Excel 2003.
RangeStr = "A4:LA24"![]()
Sub Delete_Data(SHEET as Worksheet, RangeStr) RangeStr = Make_Range(Row1, Col1, Row2, Col2) SHEET.Range(RangeStr).Delete Shift:=xlShiftUp <-- Error occurs here
So how do I fix it?
Thanks,
Mackerel
Bookmarks