Find and Replace

[kvarner]

Everywhere I can find online seems to have the same syntax for this simple find and replace. But for some reason it doesn't work.
Any ideas why?

Worksheets("BPC Upload Sheet").Range("A1:AZ500").Replace What:= "L:\Budget Tool\P33\Working File\Control File\[BPC Upload File.xlsx]", Replacement:=""

[Steve7913]

found this that might help you ... http://www.techonthenet.com/excel/fo...eplace_vba.php


copy and past from page

-------------------------

EXAMPLE (AS VBA FUNCTION)

The REPLACE function can be used in VBA code in Microsoft Excel.

Let's look at some Excel REPLACE function examples and explore how to use the REPLACE function in Excel VBA code:

Please Login or Register  to view this content.

[kvarner]

Thank you.
I saw that as well but couldn't figure out how to use that method. Maybe if I put the whole string in there for both of the first 2. But I'm not sure about referencing the worksheet either.
Maybe like this:
Worksheets("BPC Upload Sheet").Replace("L:\Budget Tool\P33\Working File\Control File\[BPC Upload File.xlsx]", "L:\Budget Tool\P33\Working File\Control File\[BPC Upload File.xlsx]", "")

[kvarner]

Nope. There's a syntax error in there somewhere.

[mrmmickle1]

That's is the proper syntax... Are you getting an error? I just copied and pasted your code and it worked fine for me.

Where did you post the code? In a code module or a worksheet module?

Try adding this additional argument:

Please Login or Register  to view this content.

[kvarner]

Well I have no idea what difference adding that would make but it works now. So strange.
Thank you!