Prev: EOMONTH compatibility issue (workaround?)
Next: paste special macro stops working when run a 2nd time
From: Nev on 5 Jun 2010 09:26
Hi there

How can I put a variable in a hypelink?
I want to access a folder within management - that folder is dependant on a
variable in cell j10. ie whatever name is in J10, click the cell and the
hyperlink will take you to the folder in c:\management\???

Can you help?

thanks

nev
From: excelent on 6 Jun 2010 05:13
=HYPERLINK("[C:\management\"&J10&"\Urfile.jpg]","Jump to whatever")


"Nev" skrev:

> Hi there
>
> How can I put a variable in a hypelink?
> I want to access a folder within management - that folder is dependant on a
> variable in cell j10. ie whatever name is in J10, click the cell and the
> hyperlink will take you to the folder in c:\management\???
>
> Can you help?
>
> thanks
>
> nev
From: excelent on 6 Jun 2010 05:27
or maby just jump to the folder

=HYPERLINK("[C:\management\"&J10&"]","Jump to whatever")


"excelent" skrev:

> =HYPERLINK("[C:\management\"&J10&"\Urfile.jpg]","Jump to whatever")
>
>
> "Nev" skrev:
>
> > Hi there
> >
> > How can I put a variable in a hypelink?
> > I want to access a folder within management - that folder is dependant on a
> > variable in cell j10. ie whatever name is in J10, click the cell and the
> > hyperlink will take you to the folder in c:\management\???
> >
> > Can you help?
> >
> > thanks
> >
> > nev
 | 
Pages: 1
Prev: EOMONTH compatibility issue (workaround?)
Next: paste special macro stops working when run a 2nd time