Search

  • Thread starter Thread starter berj
  • Start date Start date
B

berj

Is it possible to search on the results on a cell?

For example, a cell may have a formula such as

=3+5

You can search and find the 3 or the 5. The cell with show 8, is it
possible to search for an 8 and have it find this cell?

TIA
 
Yes. In the Search dialog, choose Options and select Look in Values.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
Thank you!

Niek Otten said:
Yes. In the Search dialog, choose Options and select Look in Values.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
Click to expand...
 
Saved from a previous post:

Excel tries to help by remembering the last settings you used--except for the
first search in that session.

You can use that to your advantage.

You could make a dummy workbook and put it in your xlStart folder. Have a
macro in that workbook that does a find (and sets all the stuff the way you
like). Then closes and gets out of the way.


Option Explicit
Sub auto_open()

Worksheets("sheet1").Cells.Find What:="", After:=ActiveCell, _
LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByColumns, _
SearchDirection:=xlNext, MatchCase:=False

ThisWorkbook.Close savechanges:=False

End Sub

The workbook opens, does a find (to fix your settings) and then closes to get
out of the way.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top