Consulting

Results 1 to 8 of 8

Thread: Solved: Copy and Paste with Macros

  1. 04-02-2006, 11:37 AM #1
    dimmutal
    dimmutal is offline
    VBAX Regular
    Joined
    Apr 2006
    Posts
    11

    Exclamation Solved: Copy and Paste with Macros

    Hi there. I use an expression of the form .Cells(i,2)=.Cells(i,3) to copy paste some data in Excel. However if data are HYPERLINKS then the copied data do not preserve the hyperlink but they are plain text. How can i copy data and preserve the hyperlinks? Thanks
    Reply With Quote Reply With Quote
  2. 04-02-2006, 11:59 AM #2
    Norie
    Norie is offline
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Why don't you actually copy?
    .Cells(i,2).Copy .Cells(i,3)
    Reply With Quote Reply With Quote
  3. 04-02-2006, 12:06 PM #3
    dimmutal
    dimmutal is offline
    VBAX Regular
    Joined
    Apr 2006
    Posts
    11
    Because i have 4500 lines of data!!
    Reply With Quote Reply With Quote
  4. 04-02-2006, 12:07 PM #4
    Norie
    Norie is offline
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Sorry I don't understand your reply.

    Can we see the rest of the code?
    Reply With Quote Reply With Quote
  5. 04-02-2006, 12:17 PM #5
    dimmutal
    dimmutal is offline
    VBAX Regular
    Joined
    Apr 2006
    Posts
    11
    Thanks. Quite simple. Silly of me!!
    Reply With Quote Reply With Quote
  6. 04-02-2006, 08:02 PM #6
    Norie
    Norie is offline
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Could we actually see the code?

    What you've posted implies that you're using a loop which might not be needed.
    Reply With Quote Reply With Quote
  7. 04-02-2006, 11:53 PM #7
    dimmutal
    dimmutal is offline
    VBAX Regular
    Joined
    Apr 2006
    Posts
    11
    No thanks, its ok. I replied before without seeing the answer of Norie, so my problem is solved. How do i mark this topic as solved by the way?
    Reply With Quote Reply With Quote
  8. 04-03-2006, 07:29 AM #8
    lucas
    lucas is offline
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Thread marked solved
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules