E
Ed
I have a macro which allows me to search for documents with certain
criteria, and then writes hyperlinks to those documents into a range of
cells on my active worksheet. When I do a new search or when I'm done with
the workbook, I delete the entire column. The hyperlinks are written well
to the right of and below my data range, so deleting the column doesn't
involve shifting any data or formulas, and calculation is set to manual.
I've noticed, though, that it usually takes several minutes to delete the
one single column. I could get by with just deleting the contents, but now
I'm wondering if I might have other problems brewing, with this long time to
delete a column of 14 hyperlinks as an indication. Any thoughts? Is there
anything I should be concerned with?
Ed
criteria, and then writes hyperlinks to those documents into a range of
cells on my active worksheet. When I do a new search or when I'm done with
the workbook, I delete the entire column. The hyperlinks are written well
to the right of and below my data range, so deleting the column doesn't
involve shifting any data or formulas, and calculation is set to manual.
I've noticed, though, that it usually takes several minutes to delete the
one single column. I could get by with just deleting the contents, but now
I'm wondering if I might have other problems brewing, with this long time to
delete a column of 14 hyperlinks as an indication. Any thoughts? Is there
anything I should be concerned with?
Ed