Hi all,
I am trying to write a Macro that will find and replace certain values across an entire workbook except on one worksheet. Basically I have one sheet called 'macro' where I have specified the find and replace terms. I would like to do it twice, namely:
Findtext = Sheets("Macro").Range("H8").Value
Replacetext = Sheets("Macro").Range("J8").Value
and
Findtext = Sheets("Macro").Range("H15").Value
Replacetext = Sheets("Macro").Range("J15").Value
Some of the sheets it will be replacing values in are likely to be hidden - I dont know if this causes a problem, but I would like it to apply to all hidden and unhidden sheets unless specified. I would prefer to keep it this way as over time more sheets are added and I'd prefer not to have to update the macro each time we add a new sheet. Also the second find and replace may find no relevant values so if there is someway of ignoring errors that would be ideal.
Finally, in the macro sheet I would like to be able to specify a file name path to save the file into, say in cell H20. I have no idea if possible but if the macro could save the file here and then close it that would be perfect.
Still a VBA beginner so any help would be much appreciated - attempts to hash together other macros on the net have not worked at all.
Thanks
Bookmarks