Find and replace

[Yathish.d]

Hi,

I recorded a macro to find "." and replace it with "/". I got the below code to this for me.

Please Login or Register  to view this content.

I want this to run in one single tab, but if the last used option in "find and replace" menu was for the whole workbook, this macro is replacing the "." with "/" within the whole workbook, how do I limit this for one single tab.

Thanks in advance.

Yathish

[Mordred]

Hi Yathish.d, let me know if the following does the trick for you

Please Login or Register  to view this content.

[Yathish.d]

Its working fine.

Thank you.

[flippertie]

Thanks mordred - I was looking for code to change "." to ":" in a manually entered time string, and this has given me the framework I needed!

[Mordred]

I'm glad it helped flippertie. As you can see, replacing characters is not that big of a deal. Thanks for the rep too.

[pike]

why loop?

Please Login or Register  to view this content.

[Mordred]

why loop?

I looped because I thought that once the Find is found it stops doesn't it?

[pike]

Hi,
The Range.Replace and Range.Find Methods syntax is different but similar
Once the Value is Found in the Replace the value is Changed so no need to search for it again
expression.Replace(What, Replacement, LookAt, SearchOrder, MatchCase, MatchByte, SearchFormat, ReplaceFormat)
expression.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte, SearchFormat)
the area to Replace is contained within the With Statement
The With statement lets you specify an object or user-defined type once for an entire series of statements.With statements make your procedures run faster and help you avoid repetitive typing.
hope that helps