Hi Dean, this error occurs when you have used a variable but havent declared it prior to using the variable. Declare means using the DIM keyword to define the variable name and its type. I suspect you have a line that has Option Explicit in your module where you didnt before. This enforces declaring variables. You can remove this line, or declare the variable & IMHO you should declare variables as its good programming practice.
Code:Option Explicit Sub Test() Dim LastRow As Long Range("A17").Select ActiveCell.End(xlDown).Select LastRow = Selection.Row End Sub