I believe in most cases there is little difference between Cells and
UsedArrea. VBA wil not go outside the used area unless data on the
worksheet at one time outside the used area that was deleted. After I
made the change I considered changing the Cells to Usedarea and felt it
wasn't necessary. VBA expands the Usedarea as the range of cells
expands, but doesn't reduced this range unless you delete row and/or
columns. that is why there is a number of posting asking why the
wrokbook have grown in size and how to get condense a workbook.

I didn't like Gary's solution if there was 100 or more hyperlinks. Do
you want to select 100 hyperlinks that was randomly scattered on the
worksheet. Gary probably got an error when he tried his code on cells
that didn't have a hyperlink and couldn't figure out how to avoid the
error so he told Jack to select the cells he wanted changed. I knew
there wa a count that could be used to avoid the error.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=147419