I need the range to be copied by SpecialCells(CellTypeVisible). How can I incorporate this into the 2nd line of coding (...Range) without getting an error?
Please assist.
Please Login or Register to view this content.
I need the range to be copied by SpecialCells(CellTypeVisible). How can I incorporate this into the 2nd line of coding (...Range) without getting an error?
Please assist.
Please Login or Register to view this content.
Last edited by Gard5096; 09-19-2012 at 11:10 AM.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
No, but I added a revised post that was more descriptive of the problem. I couldn't figure out how to delete this post.
Thread closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks