+ Reply to Thread
Results 1 to 4 of 4

VBA to copy only visible rows to Notepad

  1. #1
    Registered User
    Join Date
    07-21-2012
    Location
    Cannock, England
    MS-Off Ver
    2007
    Posts
    11

    Unhappy VBA to copy only visible rows to Notepad

    My code is as follows.

    it creates everything as it should but just need it to copy only visible rows.

    I have another macro that runs first to hide certain rows depending on there value.

    Please Login or Register  to view this content.
    Please Help
    Last edited by Cutter; 10-27-2012 at 05:25 PM. Reason: Added code tags

  2. #2
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: VBA to copy only visible rows to Notepad

    Untested:
    Please Login or Register  to view this content.
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    07-21-2012
    Location
    Cannock, England
    MS-Off Ver
    2007
    Posts
    11

    Re: VBA to copy only visible rows to Notepad

    Thats works great, only problem I have now, when it copies into Notepad it puts "0494,03033" around anything that was made with =CONCATENATE(B1=0494)(B2=,)(B3=03033) formula.

    Is there a way to overcome this.

    I am using it to create a Script file for AutoCad

    it only happens when , is inbetween the numbers as you can see below

    Please Login or Register  to view this content.
    Last edited by leighmetcalfe; 10-27-2012 at 08:43 PM.

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: VBA to copy only visible rows to Notepad

    @ leighmetcalfe

    Welcome to the forum.

    Please notice that [CODE] tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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