on an auxiliar sheet try

=iserror(sheet1!1:1048576)

hth
--
pleae click yes if it was helpfull
regards from Brazil
Marcelo



"coreygreat" escreveu:

I have a master lists of document names that I'm trying to hyperlink sections
to different sheets in the same workbook. I can't seem to figure out how to
drag and fill the hyperlink in a section of the column of the mastersheet,
and sequentially fill down (=sheet2!A5) to (=sheet2!A6)...and so on...linking
to sequential cells in a different worksheet. Right now, I have to 'edit
hyperlink' and change the cell value each time...I have 3000 to do! Thank
you for your help.