UPDATE:
Wigi, I've tried the Hyperlink Function in Excel. When the original cell
contains
www.xyz.com and you use the hyperlink function in say an adjacent
cell it creates the hyperlink, however the hyperlink does not contain http://
at the beginning and always says "Cannot open File" when clicked. I can add
http:// to the beginning of each web address and then use the Hyperlink
function; however I only want to show
www.xyz.com in the cell.
What I was really looking for was VB to take the value of the cell and
assign that value as the hyperlink Address and Text. From what I've seen in
some of the posts I should be able to use cell.value as the Address and Text;
however I get an error each time. So if you could help me with vb to assign
the current cell value to the hyperlink address and text I can do the rest.
Thanks,
Andrew
--
Andrew Mitchell
--
Andrew Mitchell
"AGMNS" wrote:
> It's been a long, long time since I've used a VB module / macro script and
> I'm no longer sure of the proper referencing for the cells etc.
>
>
> --
> Andrew Mitchell
>
>
> "Wigi" wrote:
>
> > Why don't you use the HYPERLINK function in Excel?
> >
> >
> > --
> > Wigi
> > http://www.wimgielis.be = Excel/VBA, soccer and music
> >
> >
> > "AGMNS" wrote:
> >
> > > I have a list of thousands of web addresses in a column. Far to many to "add
> > > hyperlink" to each manually.
> > >
> > > I would like to step through these automatically and used the current value
> > > of the cell as the Hyperlink address and Text to Display.
> > >
> > > Any suggestions would be appreciated.
> > >
> > > Thanks
> > >
> > > --
> > > Andrew Mitchell
Similar Threads
