Obviously I'm a newbie, so I'd appreciate learning how I'm messing up this code:
Sub Macro4()
'
' Macro4 Macro
'
'
Dim myRow As Long
Range("C2").Select
Selection.End(xlDown).Select
Selection.Offset(1, 0).Select
myRow = ActiveCell.Row
Rows("myRow:201").Select
End Sub
I'm simply trying to delete anything in the rows from the end of my last data through row 201. I keep getting a Type mismatch error on the last row. I assume I'm not entering the variable myRow correctly - maybe I'm missing some apostrophy's or quotation marks???
Man I hate being dumb at something!
Thanks in advance!
Mike
Bookmarks