Get last row number

 use this code to get last row number in variable.....

LastRowNumber = Range("A1").End (XlDown).Row


This code work when you data in column "A" , if your data in another column thn you hav to change your column in range......