Find/Replace not working

**narrowgate88** · 06-07-2010, 02:15 PM

The portion of the code that replaces RESET with 1RESET, works fine on it's own, but not as part of this larger code. It doesn't error out, it just does nothing. Can someone point out what I'm missing? It's at almost the end of the code.

Please Login or Register  to view this content.

**6StringJazzer** · 06-07-2010, 04:08 PM

Your code opens another workbook, I think your replace code is looking in a different workbook than you intend. To clean this up I would qualify your range. Where is your code located? Is it associated with the worksheet you want to change, or is it in a Module? I would also avoid doing a Select for this. Try this:

Please Login or Register  to view this content.

[/COLOR]

**narrowgate88** · 06-07-2010, 04:13 PM

While waiting, I think I came to that conclusion as well. This code is in a module in the Personal Macro Workbook.

I tried adding some code to save the output and then reopen, but it doesn't refresh the query data.

I'll give you suggestion a try.

**narrowgate88** · 06-07-2010, 04:19 PM

That suggestion didn't work. Still show RESET instead of 1RESET.

**6StringJazzer** · 06-07-2010, 06:27 PM

Originally Posted by narrowgate88

This code is in a module in the Personal Macro Workbook.

Your environment seems a bit much for me to try to reproduce, but this last sentence made me realize that you also need to qualify the workbook. I assume that the active workbook is the one you need to modify, so try this. The first one looks in Personal.XLS because that's where the code is.

Please Login or Register  to view this content.

**narrowgate88** · 06-08-2010, 09:20 AM

Ok, I will give that a try.

**narrowgate88** · 06-08-2010, 09:31 AM

That did not work either. So at this point, I feel like I'm either going to have to use 2 macros, or figure out a way to get the macro to import the data instead of dealing with the query.