Michael151
Board Regular
- Joined
- Sep 20, 2010
- Messages
- 247
<STYLE> st1\:*{behavior:url(#ieooui) } </STYLE>Hello all,
Trying to write a macro that will replace a word in an entire column based on the header in row 1.
In column D, replace the word “OPEN” with whatever the value is in D1. For example in column D:
Before:
NEW TEXT
OPEN
OPEN
TEXT
OPEN
After:
NEW TEXT
NEW TEXT
NEW TEXT
TEXT
NEW TEXT
Help is most appreciated - thanks!
Trying to write a macro that will replace a word in an entire column based on the header in row 1.
In column D, replace the word “OPEN” with whatever the value is in D1. For example in column D:
Before:
NEW TEXT
OPEN
OPEN
TEXT
OPEN
After:
NEW TEXT
NEW TEXT
NEW TEXT
TEXT
NEW TEXT
Help is most appreciated - thanks!
Last edited by a moderator: