find and replace
 

By default the find and replace comment searches for formulas by row.
How do I change the default to search by value and column?

find and replace
 

In the "Find & Replace" dialog window, don't you see an "Options" button?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Rwostbrock" wrote in message
...
By default the find and replace comment searches for formulas by row.
How do I change the default to search by value and column?

find and replace
 

yes, that is what I am trying to change
by default the options are set to formula and row, I would like to change
the default but do not see how

"RagDyeR" wrote:

In the "Find & Replace" dialog window, don't you see an "Options" button?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Rwostbrock" wrote in message
...
By default the find and replace comment searches for formulas by row.
How do I change the default to search by value and column?

find and replace
 

Have you tried expanding the criteria choices by clicking on the small down
arrows on the right corner of the box?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rwostbrock" wrote in message
...
yes, that is what I am trying to change
by default the options are set to formula and row, I would like to change
the default but do not see how

"RagDyeR" wrote:

In the "Find & Replace" dialog window, don't you see an "Options" button?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Rwostbrock" wrote in message
...
By default the find and replace comment searches for formulas by row.
How do I change the default to search by value and column?

find and replace
 

yes-- that only changes the settings for one use. The next time you open the
excel application, it reverts back to the original defaults.

"Ragdyer" wrote:

Have you tried expanding the criteria choices by clicking on the small down
arrows on the right corner of the box?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rwostbrock" wrote in message
...
yes, that is what I am trying to change
by default the options are set to formula and row, I would like to change
the default but do not see how

"RagDyeR" wrote:

In the "Find & Replace" dialog window, don't you see an "Options" button?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Rwostbrock" wrote in message
...
By default the find and replace comment searches for formulas by row.
How do I change the default to search by value and column?

find and replace
 

OH! ... That's what you're looking for.

I can't help you there, except to suggest recording a macro when you do it
once, and then activate it on subsequent replaces.

You might post to the programming group for some code.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rwostbrock" wrote in message
...
yes-- that only changes the settings for one use. The next time you open
the
excel application, it reverts back to the original defaults.

"Ragdyer" wrote:

Have you tried expanding the criteria choices by clicking on the small
down
arrows on the right corner of the box?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rwostbrock" wrote in message
...
yes, that is what I am trying to change
by default the options are set to formula and row, I would like to
change
the default but do not see how

"RagDyeR" wrote:

In the "Find & Replace" dialog window, don't you see an "Options"
button?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Rwostbrock" wrote in message
...
By default the find and replace comment searches for formulas by row.
How do I change the default to search by value and column?

find and replace
 

can anyone else help

"Ragdyer" wrote:

OH! ... That's what you're looking for.

I can't help you there, except to suggest recording a macro when you do it
once, and then activate it on subsequent replaces.

You might post to the programming group for some code.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rwostbrock" wrote in message
...
yes-- that only changes the settings for one use. The next time you open
the
excel application, it reverts back to the original defaults.

"Ragdyer" wrote:

Have you tried expanding the criteria choices by clicking on the small
down
arrows on the right corner of the box?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rwostbrock" wrote in message
...
yes, that is what I am trying to change
by default the options are set to formula and row, I would like to
change
the default but do not see how

"RagDyeR" wrote:

In the "Find & Replace" dialog window, don't you see an "Options"
button?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Rwostbrock" wrote in message
...
By default the find and replace comment searches for formulas by row.
How do I change the default to search by value and column?

find and replace
 

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

But if you do an Edit|Find and change anything, then those changed settings will
be remembered.

Rwostbrock wrote:

can anyone else help

"Ragdyer" wrote:

OH! ... That's what you're looking for.

I can't help you there, except to suggest recording a macro when you do it
once, and then activate it on subsequent replaces.

You might post to the programming group for some code.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rwostbrock" wrote in message
...
yes-- that only changes the settings for one use. The next time you open
the
excel application, it reverts back to the original defaults.

"Ragdyer" wrote:

Have you tried expanding the criteria choices by clicking on the small
down
arrows on the right corner of the box?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Rwostbrock" wrote in message
...
yes, that is what I am trying to change
by default the options are set to formula and row, I would like to
change
the default but do not see how

"RagDyeR" wrote:

In the "Find & Replace" dialog window, don't you see an "Options"
button?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Rwostbrock" wrote in message
...
By default the find and replace comment searches for formulas by row.
How do I change the default to search by value and column?








--

Dave Peterson