Thread: hyperlink
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SteW SteW is offline
external usenet poster
 
Posts: 293
Default hyperlink

Dear All

Trouble with the Following
=HYPERLINK("#'tour manager euro sheet'!a"&INT(((ROW()-5)/2)*43)+1,"VIEW")

This Formula is repeated In a Column on a seperate worksheet. The Intention
Being that every second Row in the column the Hyperlink should take me 44
Rows on in 'tour manager euro sheet' on column a

Can anybody help the hapless soul

Best

Stew