Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
taking "strip html" to the next level
I'm really glad I found this - and glad you took the time to write the
code. Not being a 'coder' I was wondering if my request would be possible to add into the script - I have various spreadsheets totaling 10's of thousands of cells that contain HTML tags that I need to remove the HTML from. This script definitely does that and it helps me quite a bit... My request is the following: What I envision is when I double click on a cell with HTML tags the script executes just like it does, but instead of having to manually copy the text from within the user form, then click the 'command' button, and CTRL-V back into the original cell....it would be cool if those steps were automated. In other words, the user double-clicks the cell and "bingo" the HTML markup cell contents are replaced with the non-HTML content. If you could select an entire column and put all that code in "For...Next" (i'm sure for...next isn't correct) loop and the script executes all the way down the column with one double-click - that would *really* be cool...but if somebody could show me how to do the simplest automation I'd greatly appreciate it.... making my way through about 15,000 rows and 3 columns is going to be a lot of double-clicks, CTRL-C, click, CTRL-V, Arrow Down....repeat.....don't get me wrong though...I'm very appreciative to have what you've already provided! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Sub to strip away "Sheet" prefix from names | Excel Programming | |||
how do I stop "copy" taking a picture instead of copying text | Excel Discussion (Misc queries) | |||
"Strip" Cell Formula | Excel Programming | |||
Hiding "work" taking place on a worksheet. | Excel Programming |