Select Cellright clickhyperlinkin this filesheetcell ref. Hope this is
what you mean.
Pat F

"venkat" wrote:

I want to extend the hyperlinks across all cells in one worksheet..... like
cell A1 in sheet 1 should point to cell A1 in sheet2 and so on..... i have
500 cells in both sheets....