I have the following code that keeps giving me the error message " Run-time error '1004': Method 'Range' of object'_Gloabl' Failed"
Can someone please help me.
Code:
Sub errorhandling()
Worksheets("Sheet1").Select
On Error GoTo E6:
Range("SACC6").Cells(Range("SACC6").Rows.Count, 1).Offset(1, 0).Activate
E6:
On Error GoTo Err8:
Range("SACC7").Cells(Range("SACC7").Rows.Count, 1).Activate
Err8:
End Sub
Bookmarks