Is it Possible to do this??

[julvaz]

Hello all,

Is it possible to create a macro in order to use the find/replace feature from excel. I tried to record a macro by clicking on Edit, then Find. I stopped the macro and when I ran it, it didn't do anything. Thanks

[MDubbelboer]

to do a find
expression.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte, SearchFormat)

to do a replace

expression.Replace(What, Replacement, LookAt, SearchOrder, MatchCase, MatchByte, SearchFormat, ReplaceFormat)


in my usage "expression" is generally replaced with the range in which you want to search.

[Mhz]

I use this formula below to initiate the Find/Replace Dialogue In a Macro:

Sub FindReplace()

SendKeys "^f", False

End Sub

[julvaz]

I use this formula below to initiate the Find/Replace Dialogue In a Macro:

Sub FindReplace()

SendKeys "^f", False

End Sub

Mhz,


Thanks buddy that's it, great! and thanks to all for responding. One question though, what is this "SendKeys "^f", False"

[MDubbelboer]

lol, sorry totally-misread

[julvaz]

lol, sorry totally-misread

MDubbelboer,

No problem bud, I actually did what you sent and it works fine also. I had to tweakk the code some, but it does what I want it to do.

[Mhz]

Thanks Julvaz, This Credit Is Deservingly of Leith Ross whom showed me this
Code. He has also helped me with other questions.. Thumbs Up for Leith Ross on This weird VBA Code.. It definately Works...

[julvaz]

Hey Mhz

Is there a code I can use along with the code below so that when I click on close it takes me to another worksheet?

Sub FindReplace()

SendKeys "^f", False

End Sub

[julvaz]

Hello all,

Is there a code I can use along with the code below so that when I click on close it takes me to another worksheet? Right now the way I have it, it takes me to the Master List worksheet when I run the code, but how about ot go back to the first worksheet when I click on close on Find/Replace?

Please Login or Register  to view this content.

Thanks