Code:
Columns("AN").Insert Shift:=xlRight
LastRow = Range("E4:E").Cells.Find("*", _
SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
' MsgBox "The Last Non-Blank Row Is " & LastRow
Range("AN4:AN" & LastRow) = "*"
I keep getting the same error, and I don't know why!
Ive declared DIM LastRow as Long
HTML:
Run Time Error 1004
Method Range of Object_Global Failed
What am I doing wrong?
Thanks for the help
excel 2013
Last edited: