| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
replace in a split?
If i have a cell with a comment in it and that comment has say 4 lines :
one two three four I know I can refer to a single line by using Range(CurrAddress).Comment.text, vbLf)(2) which would refer to "Three" But what if i want to replace the "three" with "someting else"? Range(CurrAddress).Comment.text, vbLf)(2)="Something Else" doesn't work.... Thanks in advance Kevin Green |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| How do I remove split a split window? | New Users to Excel | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Using Find and Replace to replace " in a macro | Excel Programming | |||
| Replace method - cannot find any data to replace | Excel Programming | |||
Threaded Mode
