Thread: Replace Return
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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