View Single Post
  #1   Report Post  
Jeff
 
Posts: n/a
Default Cell.Find in VBA

Hi,
I have the following VBA Macro:
Set FoundCell = .Cells.Find(What:="199", _
After:=.Cells(1), LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious, _
MatchCase:=False)

I don't how to write a VBA macro that would cells.find all 5-digit numbers.
Here's an example:
Column A
199
199
75781
75899
199
80012
Thanks,