Hey guys, I am stuck with a simple problem.
I have this code which copies range "B11:Q31" from sheet "Invoice" to "invoice data" and skips the blank cells.
Now i want to copy from range "B11:R31" from sheet "Invoice" to "invoice data".
I want to do the same thing but want to copy range "R11:R31" as well. I want to paste it in sheet "Invoice data" - column "W"
The code which i have is
Please Login or Register to view this content.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hey Bakerman.
Thank you so much, You have helped me so much.
Thanks for bieng so kind. Thank You
Glad to help and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks