I have the following code that is running slowly. Is there another way to speed up the copy and paste function that it is performing? The copy range should always start in cell B3 and the last row of the copy range will vary every time I run the code. Any help would be appreciated.
Please Login or Register to view this content.
Last edited by rhudgins; 02-01-2011 at 11:09 AM.
You don't need to select. There's 100s of examples of copying data correctly on the forum
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Try
Please Login or Register to view this content.
Martin
Don't use copy to copy:
Please Login or Register to view this content.
There are blank cells in the code range so currentregion.copy does not work. Any other ideas?
SNB - The range B3:Q5999 will sometimes be larger and other times smaller. (ex:B3:Q3000, B3:Q10000). Is there a way to change the code to capture this?
The more information you give the more specific the answer can be.Please Login or Register to view this content.
Blank cells do not jeopardize currentregion, empty rows/columns do.
Last edited by snb; 01-31-2011 at 05:25 PM.
I am getting a syntax error on the first line..
Me too.
I think you need to scrutinize the code to improve it.
I really don't know how to fix it. The colon and [] are confusing me.
Maybe your VBEditor has some help-facility ?
Please show me how to fix it so that I will know for the next time.
What determines the last cell to be copied? Is it the last used cell in col Q?
What's the worksheet name in each workbook?
Entia non sunt multiplicanda sine necessitate
The last cell to be copied is the last used cell in column Q.
The worksheet name is called "AnalystRecommendations" in workbook "ANR for multiple tickers" and "Today" in workbook ANR for multiple tickers 2.
If you declare object variables, you get IntelliSense so you're not coding blind.
Please Login or Register to view this content.
Thanks so much. I recieved one error at the line .PasteSpecial Paste:=xlPasteValues "This operation requires the merged cells to be identically sized."
Can you help me fix this?
Unmerge all merged cells, the scourge of Excel.
I have a moral aversion to solving any problems related to merged cells.
Last edited by shg; 02-01-2011 at 12:04 PM.
I did. Read the posted code again.Please show me how to fix it so that I will know for the next time.
Thanks this works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks