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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA 1
VBA - retrieve data on last create named range from previous inserted named range 0
Paste in column B using Last row of either column B, C or D. 10
Excel Subtracting multiple columns from another column 3
Excel Row & Column question 1
Excel Concatenate with line breaks but ignore blank cells 3
Renaming Columns A, B, C, D, E, etc. in Excel? 5

Back
Top