Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Boell Fischer   on Feb 27 In MS Office Category.

HOW TO FIND LAST CELL VALUE IN PARTICULAR COLUMN AND ROW IN EXCEL


  
Question Answered By: Nicolas Costa   on Feb 27

Sub LastRow()
'By going to the last row  in excel  and then moving up (like Control-UpArrow in
Excel), you will find  the data you are looking for
YourValue = Range("A65536").End(xlUp).Value
Message = MsgBox("The data in the last row is: " & YourValue)
End Sub

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 


Tagged: