| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Cell.Replace question
Thank you for your assistance, I should have been able to find this.
Thanks again. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
| Excel - create button to replace cell content with cell value | Excel Worksheet Functions | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| EXCEL : Replace a value in a cell by a picture | Excel Discussion (Misc queries) | |||
| turn off the " replace file?" question when saving excel files | Excel Programming | |||
Linear Mode
