I think you would need to export it to a text editor like Textpad and do it
there.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R Avery" wrote in message
...
I'm sorry, I was not clear enough. I am familiar with using RegEx in VB
functions, but the VBE Search and Replace form supports wildcards, but
not RegEx. Is there a VBE Extensibility addin that enables RegEx search
and replace in the code editor. Typical examples would be: I have a
function with like 50 lines of var1 = cells(1,1).value, var2 =
cells(2,1).value, etc, and I would like to reverse the equality so that
it instead reads cells(1,1).value = var1, cells(2,1).value = var2.

As far as i know, things like this cannot be done using wildcards.




Tom Ogilvy wrote:

http://msdn.microsoft.com/library/de...ting051099.asp

Can be called from VBA.