LastRow = Cells(Rows.Count, "A").End(xlUp).Row

MsgBox Cells(LastRow, "B").Value - Cells(LastRow, "D").Value

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Sivassou..." wrote in message
...
Hi,

Need a help.

1. Macro to get final Last row no. from the user
2. Calculate the TAT (diff. between any two column) with the last row no.

Your help on this would be highly appreciated.

Bye,
Sivassou.