Find/search function/example request.

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

Does anyone have an example of finding information in excel and reading the
information into VB or VBA (preferably VB)?

Thanks,
Aaron
 
here is the help example for using the find method of the range object in
Excel:

With Worksheets(1).Range("a1:a500")
Set c = .Find(2, lookin:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address
Do
c.Interior.Pattern = xlPatternGray50
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstAddress
End If
End WithFind has many more arguments. You can see and example of them by
turning on the macro recorder (tools=>Macros=>record a new macro) and then
 
Back
Top