+ Reply to Thread
Results 1 to 9 of 9

Copy Text

  1. 11-12-2008, 07:24 AM #1
    aftabn10
    aftabn10 is offline
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    287

    Copy Text

    Hi, i am looking to write a macro to copy text from every 3rd row in my worksheet and then paste this elsewhere. How is this possible?

    Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 11-12-2008, 07:39 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Something like this

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  3. 11-12-2008, 08:04 AM #3
    aftabn10
    aftabn10 is offline
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    287
    Thanks royUK, ill give that a go.
    Reply With QuoteRegister To Reply
  4. 11-12-2008, 08:09 AM #4
    aftabn10
    aftabn10 is offline
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    287
    royuk, I get a run-time error '1004' on the following line:

    Please Login or Register  to view this content.
    Any ideas why?
    Last edited by royUK; 11-12-2008 at 08:49 AM.
    Reply With QuoteRegister To Reply
  5. 11-12-2008, 08:12 AM #5
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Please use Code Tags.

    Have you got a sheet2?
    Reply With QuoteRegister To Reply
  6. 11-12-2008, 08:29 AM #6
    aftabn10
    aftabn10 is offline
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    287
    Sorry royuk. I do have Sheet2 and Sheet3 so thats why i dont understand why it comes up with the error. Any ideas?

    Thanks once again.
    Reply With QuoteRegister To Reply
  7. 11-12-2008, 08:36 AM #7
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    No, can you attach the workbook
    Reply With QuoteRegister To Reply
  8. 11-12-2008, 08:44 AM #8
    aftabn10
    aftabn10 is offline
    Forum Contributor
    Join Date
    06-16-2008
    Posts
    287
    royuk, for some odd reason it comes up with the error, but it has now copied the text over. Thanks for all your help!
    Reply With QuoteRegister To Reply
  9. 11-12-2008, 08:48 AM #9
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    It shouldn't give any error. Try this
    Please Login or Register  to view this content.
    Last edited by royUK; 11-12-2008 at 08:51 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1