Hello
I'm using the following code to copy blocks of data, equal column size across yet different row sizes down into a central table.
Yet when I copy the TableWest I would like PasteSpecial Values to pasted, not copied. I tried replicating the code from above, whilst using the "find last cell used" yet can't figure it out.
Any suggestions? Also, any suggestion on a more efficient way of copying would be appreciated.
Cheers
Please Login or Register to view this content.
This may work for you, and it avoids the various select statements which are usually unnecessary.
Please Login or Register to view this content.
Thanks pjoaquin - that code seems to work great.
May I ask a question, such that I can learn?
When the data is copied from TableEast, the With is with TableEast. Yet when data is copied from TableWest, the With is with TableTotal. Why?
Thanks
Glad it worked for you.
The reason I used 'With TableEast' in the first bit of code is because 'Sheets("TableEast")' would occur twice in that section of code, while 'Sheets("TableTotal")' occurs only once, and it's in a short line of code.
In the second section of code, while TableWest and TableTotal both occur twice, if I had kept the Sheets("TableTotal") in the second line of code twice it would have made it quite a bit longer. Here's the same code, but using 'With Sheets("TableWest")' instead of 'With Sheets("TableTotal")':
Yes, you can break a long line of code using " _", but I prefer code that fits on one line if at all possible. Just preference.Please Login or Register to view this content.
Thank you for taking the time to explain the code pjoaquin - i've learnt something new.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks