Last column no.

[Sivassou...]

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.

 

[Bob Phillips]

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)