Search and Replace

M

Muttley

I'm wanting to search and replace a worksheet, but rather than replace with a
set bit of text, I want to replace it with something defined within my VBA
code:

Cells.Replace What:="Annuity L_All", Replacement:=file_noxls, LookAt _
:=xlPart, SearchOrder:=xlByRows, MatchCase:=False,
SearchFormat:=False, _
ReplaceFormat:=False

The "replace" text is definitely there, but when I run the code, it doesn't
repalce anything... can anyone help / spot the obvious error?

Thanks! :)
 
R

Rick Rothstein

Your code snippet works for me. Just out of curiosity, is the worksheet that
contains your "Annuity L_All" text the ActiveWorksheet (the Cells property
is not referencing any particular worksheet, so it will refer to the
ActiveSheet by default)?
 
J

Jacob Skaria

Refers ActiveSheet..

Dim file_noxls As String
file_noxls = "replaced"
Cells.Replace What:="Annuity L_All", _
Replacement:=file_noxls, SearchOrder:=xlByRows

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find and replace multiple values in one statement 3
Using Cell.Replace 1
Limits of Substitute and Replace functions 4
How to add "'" into string? 9
Printing Macro 4
replace text with a loop 6
search and replace loop problem 7
replace 29 february with 28 february with vba 4

Top