Are they =HYPERLINK functions or Inserted hyperlinks??
--
Gary''s Student - gsnu200750


"pcor" wrote:

I have about 200 entries in col a
Some of these entries are hyperlinks to other locations
I would like a macro to copy ONLY the hyperlinks from Col a to Col b
Currently the hyperlinked items are interspaced over the entire col a, I
would like to have all the hyperlinks moved to Col B one under the other
with no spaces.
Thanks