| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace Return
How do I get the Replace method to return a boolean of whether it has
replaced values or not? It's default return value only seems to indicate that there are chacters present in the target range or not, but not whether it made a replacement or not. Getting frazzeled, Trent Argante [DC.J(455)] |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace Return
Maybe do a find first to see if the value is in the range to start.
Trent Argante wrote: How do I get the Replace method to return a boolean of whether it has replaced values or not? It's default return value only seems to indicate that there are chacters present in the target range or not, but not whether it made a replacement or not. Getting frazzeled, Trent Argante [DC.J(455)] -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace Return
Good idea, thanks, Dave.
-- Trent Argante [DC.J(455)] "Dave Peterson" wrote: Maybe do a find first to see if the value is in the range to start. Trent Argante wrote: How do I get the Replace method to return a boolean of whether it has replaced values or not? It's default return value only seems to indicate that there are chacters present in the target range or not, but not whether it made a replacement or not. Getting frazzeled, Trent Argante [DC.J(455)] -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace hard return with a delimiter? | Excel Worksheet Functions | |||
| Carriage Return By Replace() function | Excel Discussion (Misc queries) | |||
| Replace ; with hard return | Excel Discussion (Misc queries) | |||
| How do I replace a return value of #N/A in a vlookup with zero? | Excel Worksheet Functions | |||
| how to replace a hard return? | Excel Programming | |||
Linear Mode
