View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rajaiy rajaiy is offline
external usenet poster
 
Posts: 8
Default auto scrol doune for hyperlink.

Dears,

I have one excel sheet, I need to make auto scrol doun fore the hyperlink,
like this example,

a1 = 419 b1= \\appserver\users\FILE 02-\419.xls.

so how I can make auto hyperlink as the next cell will call the next file no
150 from the same folder as .

a2 = 420 b2= \\appserver\users\FILE 02-\420.xls.
and go on.

Thanks for help...