Hi,
Found this on Internet for last row
XRow = Sheet1.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
Looks like it count OK the last row if there is data in Coulmn A, which is not the case all the time
How can this be changed if I know that all the time in row there is data in Column 80
or better
How can this be changed to look for last row with data in range A7:EZ5000
Thanks
Bookmarks