+ Reply to Thread
Results 1 to 1 of 1

Macro to cut and paste but recognise a hyperlink

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    2019
    Posts
    451

    Question Macro to cut and paste but recognise a hyperlink

    Hi All,

    With a Macro I have the following code:

    Sheets("DataSheet").Select
        Range("E2").Select
        Application.CutCopyMode = False
        Selection.Copy
        Sheets("Alert Notification Form (2)").Select
        Range("G5").Select
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
    However, sometimes, but not always, the data being cut and paste may be a hyperlink to a website. Is there any way I can modify this code so it looks to identify whether or not it's a hyperlink and if it is retain the hyperlink properties in the sheet it is pasted to?

    Alternatively, is there something I can do after pasting that would 'activate' the hyperlink? I tried recording the macro using F2 and enter, but all that did was change the posting to specific text.

    Many thanks

    Terry
    Last edited by MagicMan; 07-30-2014 at 05:21 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel macro to modify Hyperlink to copy and paste
    By jffwright82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2014, 03:55 PM
  2. Macro to hyperlink and copy/paste value to 2nd worksheet???
    By AudreaBull in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2013, 05:27 AM
  3. macro to move 1 cell left and paste CURRENT clipboard content as HYPERLINK
    By sgoesef in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2013, 01:31 PM
  4. [SOLVED] Macro to Copy data and Paste it into every 7th row in another sheet with hyperlink
    By dani_n88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-08-2012, 11:22 PM
  5. Macro to Copy and Paste the hyperlink cell value.
    By mvel_sky in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2009, 12:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1