Last column no.

  • Thread starter Thread starter Sivassou...
  • Start date Start date
S

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.
 
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)
 
Back
Top