Find/replace [Zx] with [Znumber]

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with cells in column A containing text only. I need to
locate each instance of [Zx] and replace it with [Znumber]. For example: In
cell A1 the first [Zx] substring needs to be replaced with [Z1]. The second
instance of [Zx] needs to be replaced with [Z2]. If there are no more
instances in A1, then moving down to A2, the first instance of [Zx] in A2
needs to be replaced with [Z3], etc.

I only know how to do find/replace with fixed strings.

Thanks in Advance
 
Gary,

You cannot use Replace which is probably what you are used to, but you need
to use Find and FindNext. Take a look in VBA help for details.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Back
Top