Thread: VBA 1004 Error Deleting Rows or Columns

The following causes a "Error 1004 Method 'Range' of Object '_Worksheet' failed.
I'm working in Excel 2003.

Sub Delete_Data(SHEET as Worksheet, RangeStr)
    RangeStr = Make_Range(Row1, Col1, Row2, Col2)
     SHEET.Range(RangeStr).Delete Shift:=xlShiftUp             <-- Error occurs here

RangeStr = "A4:LA24"

So how do I fix it?
Thanks,
Mackerel

The problem turned out to be that I was specifying a column larger than the work space.

But I can't figure out how to mark this thread as "Solved"?

Mac