Quick Question on Hyperlinks
 

Dave

One last question, if I am using it in a: for i = 1 to lastrow an
have this statement in the

myhyper = "'" & tsht.name & "'!c9"

I want the hyperlink to be Column C but Row i, how would you change th
statement? Again I can't seem to get my variables working on this.
Thanks again.

R

--
Message posted from http://www.ExcelForum.com

Quick Question on Hyperlinks
 

how about:

myhyper = "'" & tsht.name & "'!c" & i



"rickey24 <" wrote:

Dave

One last question, if I am using it in a: for i = 1 to lastrow and
have this statement in the

myhyper = "'" & tsht.name & "'!c9"

I want the hyperlink to be Column C but Row i, how would you change the
statement? Again I can't seem to get my variables working on this.
Thanks again.

RH

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

Quick Question on Hyperlinks
 

Awesome, thanks

--
Message posted from http://www.ExcelForum.com