Help! Why am I getting Run-time error '1004': Method 'Range' of object'_Gloabl' Failed

I'm not sure where you're code is bombing out without a sample of what you're working with but I'd start with checking your references. Does it actually begin on Sheet1 and so forth.

Thanks Jluc,

The code can be pasted in any workbook and ran and the error will appear.

You can open up a new workbook and paste the code and run it. As long as you have a tab named "Sheet1", then the error will appear

Figured it out! I could have used On Error Resume Next, but the example below allows the use of On Error Goto mulitple times within a single sub routine.

Sub errorhandling()
On Error GoTo E6:
Worksheets("Sheet1").Select
On Error GoTo E6:
Range("SACC6").Cells(Range("SACC6").Rows.Count, 1).Offset(1, 0).Activate
E6:
Resume Check2
Check2:
On Error GoTo Err8:
Range("SACC7").Cells(Range("SACC7").Rows.Count, 1).Offset(1, 0).Activate
Err8:
End Sub