need to find last active row in EXcel

[sunil0780]

Hi
I have record in first three column
it is some albha numeric
once we all record over I have empty row then some declaration.

I need to have to find the last row having record (before that empty row)

thanks
Sunil

[shrivallabha]

Welcome to the board!
You should be using:
lLastRow = Range("A" & Rows.Count).End(xlUp).Row