Url As String. Need as Range. Unsure of syntax required

[cossie2k]

Hi All,

I have a macro which downloads a file from a sharepoint site and saves it to the desktop for onward use.

Please Login or Register  to view this content.

and various subsets with no luck.

Secondly, I may have two or more links, depending on the selection of a dropdown field. As such if the value = 1 then A1 is selected. If the value is 2 then A2 is selected.

Thanks for all your help
Alex

[AlphaFrog]

Please Login or Register  to view this content.

Secondly, I may have two or more links, depending on the selection of a dropdown field. As such if the value = 1 then A1 is selected. If the value is 2 then A2 is selected.

Please Login or Register  to view this content.

[Olly]

To answer the first part of your question:

Please Login or Register  to view this content.

Now to answer the second question: you can simply offset the reference depending on the value returned by your dropdown field:

Please Login or Register  to view this content.

[cossie2k]

Fantastic! Thank you so much for your help!

Kind regards
Alex