Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Bing Fischer   on Sep 09 In MS Office Category.

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


  
Question Answered By: Marina Smith   on Sep 09

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 3 more answer(s). View Complete Question Thread

 


Tagged: