Hi guys.
Need some help with a code that does the following:
1- Copy a dynamic range of data (starts in column "BQ2" and could have more or less rows and columns, so it should copy till there arenīt more data, up and down)
2- Open a new workbook.
3- Paste this data with the same formats (there are dates and numbers) and in the same order, starting on cell "B2" in this new workbook.
Thanks in advance
Hi,
Untested in the absence of a workbook but perhaps
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard and thanks for the reply. So i try your code and it gives me "run time error 1004. PasteSpecial method of Range class failed.
Sorry im really noob in VBA. I just change 'Sheet1' to the name of the sheet i have, could it be this change?
One thing i notice is that my active sheet has all sheet selected probably to paste when it should be just "BQ" and all the columns and rows that have data in.
Thanks again
Last edited by bazofio; 01-26-2015 at 10:17 AM.
OK so i try just to copy a designated range and its working.
This is the code i use:
What i want was to just copy the columns and rows that have data, starting in "BQ2". Can this be done?Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks