View Single Post
Old 08-26-2019, 01:32 PM
Mark2438 Mark2438 is offline Windows 7 64bit Office 2007
Join Date: Aug 2019
Posts: 4
Mark2438 is on a distinguished road

BOUNTIFUL THANKS to you, NoSparks, for your continuing help on this matter.
I hope that my previous post is sufficient to keep me from getting 86'd.

What the heck are you talking about ?
Do you have more than one workbook open ?

No other workbooks are open, but now I understand:
As mentioned earlier, I had tried to use MrExcelHTMLMaker, so that script was still active.
I unchecked it, restarted, and all is well. I now see only your script.

I understand how you referenced the column A cells with the "-1" offset. Cool.

Again, I changed it to Set rng = .Range("B10:B20") and TextToDisplay:="Click"
then Saved the file, exited Excel, and reopened the file.
Cell A28 Still Works, and all the column A cells still say "Click here".
Apparently, I need to "run" the script again, after re-opening the file?
Is the script not automatically Run when the file is Opened?

You noticed: in my original sample cells, the INTRO cells have %0D%0A for CR/LF,
while the BODY cells do not. That's because: some time ago, the emails were not displaying correctly.
I've just changed the text in the INTRO cells, to look like the BODY cells, and it works well. No more %0A%0D.
Reply With Quote