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.

  
Question Answered By: Djoser Massri   on Feb 27

With the new Excel 2007 coming out with its 1 million rows, it is best
not to identify a starting cell  range in the search. It is better to use
the following line of code when searching a column  for the last cell.



Value = Cells(Rows.Count, "A").End(xlup).Row



Change "A" to whatever column you are using.

Share: 

 

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

 


Tagged: