how to hyperlink b/w two sheets?
 

Tariq,
Use a formula like =HYPERLINK("c:\book1.xls#A10","ClickMe")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Tariq" wrote in message
...
Hi,

can any one tell me how to hyperlink b/w two sheets in Excel automation?

im workin in vb.net.

Thankz!

Tariq

how to hyperlink b/w two sheets?
 

thanks Chip for ur immediate reply, but could u tell me plz how can this
formula be implemented to refer to sheet2 from sheet1?
for e.g. i hav 3 sheets in excel and i want to hyperlink sheet 1's 6th cell
to sheet 2's 7th cell, so wat would be the formula in that scenario?

thankz!

Tariq

"Chip Pearson" wrote:

Tariq,
Use a formula like =HYPERLINK("c:\book1.xls#A10","ClickMe")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Tariq" wrote in message
...
Hi,

can any one tell me how to hyperlink b/w two sheets in Excel automation?

im workin in vb.net.

Thankz!

Tariq