VBA Find/replace advanced options

[Stuts]

Hi All,

I have a macro which converts a spreadsheet I use on a regular basis into a csv file for importing into a different software package.

Part of the macro code is to find and replace data within the sheet, this generally works very well; however I have identified a fault with it which is that if I have used the find/replace option manually prior to running the macro and I have been searching an entire workbook when i run the macro it remembers that I have been searching the book and does this within the macro.

Please can you advise what the code is to determine whether a replace looks up across the workbook or worksheet?

Thanks,