Searching through other posts I found this coding which I have used to generate one kind of sheet I need
Now I'm hoping to use the same type of coding but rather than copying the entire row I want to copy only certain columns but not consecutive (ie. A-C and I-M)
Please Login or Register to view this content.
Any help/suggestions?
Also just noticed it is printing all entries with value=1 and then the last row is one entry with value = 2, any help with that?
Many Thanks
Last edited by liz80; 08-18-2012 at 03:19 PM.
hi liz80, welcome to Excelforum, change this to copy columns I to M:
to this:Please Login or Register to view this content.
Please Login or Register to view this content.
---------- Post added at 12:33 PM ---------- Previous post was at 12:31 PM ----------
to copy A-C and I-M change same line to:
Please Login or Register to view this content.
Hi Liz80,
Try this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Solved - Thank you!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks