Run Time Error on Code that Hasn't Changed in Years

[spacle]

Hi! I am getting a Run Time Error '1004': Method 'Range' of Object '_Global' failed on the last line of code here in a Workbook that has been working fine for years, where nothing has changed. Since it has been 10 years since I wrote the code for this workbook, my VBA skills are rusty to say the least. Does anything about the code below stand out as being off?

Thanks in advance!

Dim LR As Long
    LR = Range("A" & Rows.Count).End(xlUp).Row
    Range("$A$1:$L" & lastRow).Select

 

[jkpieterse]

You seem to have both a LR and a lastRow variable in that code. Since lastRow isn't assigned a value, well, it is zero.

 

[spacle]

You seem to have both a LR and a lastRow variable in that code. Since lastRow isn't assigned a value, well, it is zero.

That did the trick! Thanks very much, jkpieterse!