LinkBack URL
About LinkBacks
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 Help
Please Login or Register to view this content.
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 HelpPlease Login or Register to view this content.
Last edited by Cutter; 10-27-2012 at 05:25 PM. Reason: Added code tags
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.
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.
@ 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks