Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and Replace
Hi There,
I am writing a macro that SEARCH and REPLACE text or word within my excel file. Can anyone help me on this please. Aprpeciate your help. Thanks Eric |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and Replace
Hi Eric,
I am writing a macro that SEARCH and REPLACE text or word within my excel file. Can anyone help me on this please. Why a macro, doesn't control-f or control-h fit your need? Are you aware of my Flexfind utility: www.jkp-ads.com/Download.htm#Flexfind Regards, Jan Karel Pieterse Excel MVP www.jkp-ads.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and Replace
Turn on the macro recorder
do Edit=Replace and enter the proper arguments, click OK Turn off the macro recorder and examine the code recorded. -- Regards, Tom Ogilvy "Eric" wrote in message ... Hi There, I am writing a macro that SEARCH and REPLACE text or word within my excel file. Can anyone help me on this please. Aprpeciate your help. Thanks Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search and replace | Excel Worksheet Functions | |||
search & replace | Excel Worksheet Functions | |||
Search & Replace | Excel Programming | |||
Search & Replace | Excel Programming | |||
Search and Replace... | Excel Programming |