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
Bookmarks