| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find and replace inside comments?
I have a large range of cells that contain comments. I want to change the
word linear to exponential in all the comments. Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find and replace inside comments?
Hi try this, it's case sensitive so you may need to play with the strings
Sub stitute() For Each Comment In ActiveSheet.Comments Comment.Text Text:=Replace(Comment.Text, "linear", "exponental") Next End Sub Mike "Knox" wrote: I have a large range of cells that contain comments. I want to change the word linear to exponential in all the comments. Is there a way to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find and replace inside comments?
you are the man! thanx!
"Mike H" wrote: Hi try this, it's case sensitive so you may need to play with the strings Sub stitute() For Each Comment In ActiveSheet.Comments Comment.Text Text:=Replace(Comment.Text, "linear", "exponental") Next End Sub Mike "Knox" wrote: I have a large range of cells that contain comments. I want to change the word linear to exponential in all the comments. Is there a way to do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find and replace inside comments?
Replace does have another argument that you can specify to make it
case-insensitive. But that doesn't mean that the case of the replaced word would match the case of the existing word, though. Mike H wrote: Hi try this, it's case sensitive so you may need to play with the strings Sub stitute() For Each Comment In ActiveSheet.Comments Comment.Text Text:=Replace(Comment.Text, "linear", "exponental") Next End Sub Mike "Knox" wrote: I have a large range of cells that contain comments. I want to change the word linear to exponential in all the comments. Is there a way to do this? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comments inside the chart | Charts and Charting in Excel | |||
| Find and replace Comments | Excel Worksheet Functions | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| How do you find and replace text in autoshapes or comments | Excel Discussion (Misc queries) | |||
| Find and replace for comments in excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
