Good afternoon, I am having an issue where excel is not going to the last row of data. The code line I am using is the following.

ActiveCell.SpecialCells(xlLastCell).Select
           lrow = ActiveCell.Row
           Lcol = ActiveCell.Column

Range("AJ2:BS2").Select
    Selection.Copy
    Range("AJ3").Select
    Range("AJ3:AJ" & lrow).Select
    ActiveSheet.Paste
    Application.CutCopyMode = False
What happens is when it looks for the last row of data it goes 3 or 4 rows past the last row of actual data. Any thoughts on how to get past the "dirty" cells? Thanks in advance.

AWBF