Excel Cell.Replace question
 

Is there a way to limit the scope of the Cell.Replace function to a
selected row? When ever I use this function it replaces everything on
the worksheet.

Excel Cell.Replace question
 

rows(3).Replace

--
Regards,
Tom Ogilvy


wrote in message
oups.com...
Is there a way to limit the scope of the Cell.Replace function to a
selected row? When ever I use this function it replaces everything on
the worksheet.

Excel Cell.Replace question
 

Teh replace function acts on a range of cells. I find it most convenient to
use a range object for this type of thing. Something like...

dim rng as range

set rng = sheets("Sheet1").columns(1)

rng.replace ...

Which will perform the replace on column A
--
HTH...

Jim Thomlinson


" wrote:

Is there a way to limit the scope of the Cell.Replace function to a
selected row? When ever I use this function it replaces everything on
the worksheet.

Excel Cell.Replace question
 

Thank you for your assistance, I should have been able to find this.
Thanks again.