PC Review


Reply
Thread Tools Rate Thread

Copying hyperlinks with VBA in Excel 2003

 
 
ian
Guest
Posts: n/a
 
      8th Aug 2007
I am using a macro to copy data from one sheet to a new sheet and a
new workbook.

The original sheet has a column of working hyperlinks.

I am copying with code like this:

Workbooks("New workbook.xls").Sheets("Sheet1").Range("a" & i & ":dz" &
i).Value = _
Range("a" & i & ":dz" & i).Value

The hyperlinks do not work in the new sheets.

How can I format the cells as hyperlinks or copy the original
hyperlinks as hyperlinks?


Thanks

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Update 2000 Excel hyperlinks to 2003 hyperlinks =?Utf-8?B?bG9udjE1NQ==?= Microsoft Excel Worksheet Functions 4 25th Oct 2007 05:51 AM
Hyperlinks between two cells and referntially copying hyperlinks Chris Swinney Microsoft Excel Discussion 0 6th Mar 2007 09:44 AM
Hyperlinks from Excel 2000 dont work anymore in Excel 2003 =?Utf-8?B?QWdyb24gU2h1amFrdQ==?= Microsoft Excel Misc 0 18th Jan 2006 02:21 PM
Copying HTML into Excel Losing Hyperlinks =?Utf-8?B?RGF2dWQgTGV2aXR0?= Microsoft Excel Misc 2 31st Oct 2005 01:02 AM
Re: WHY DO HYPERLINKS IN EXCEL 2003 NOT WORK IN EXCEL 2000 Echo S Microsoft Powerpoint 0 26th Aug 2004 07:25 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:29 AM.