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)

"Gary''s Student" wrote in message
...
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''s Student