I'm bringing in some tables from a web page. The cell contents I want
to keep are those that have text that is hyperlinked. There are other
cells that are a hyperlink only (no text) or text only that I want to
clear. What approach should I take? I'm thinking I can loop through
the range, but I'm never worked with this type of data and don't know
how to specify the conditions for clearing the unwanted cells.
TIA,
Jim