Logo 
Search:

MS Office Answers

 Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Hayrah Burki   on Mar 02 In MS Office Category.

Search for date in column


  
Question Answered By: Connie Wallace   on Mar 02

To search  only column  B (for example), maybe something like:

Columns("B:B").Select
Set rCell = Selection.Find(What:=CDate(strdate), After:=Range("B5"), _
LookIn:=xlFormulas, LookAt:=xlWhole, _
SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False)
rCell.Select
RowNo = ActiveCell.Row

Share: 

 

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

 
Didn't find what you were looking for? Find more on Search for date in column Or get search suggestion and latest updates.


Tagged: