http___www.thecodecage.com_forumz_hr_tags__1.xml
2.1 4.1 5.1 6.1 8.1 10.1 11.1 12.1 12.2 13.1 14.1 14.2 15.1 16.1 18.1 20.1 21.1 23.1 25.1 26.1 27.1 27.2 27.3 28.1 30.1 32.1 33.1 34.1 35.1 35.2 36.1 36.2 38.1 40.1 41.1 43.1 45.1 46.1 46.2 46.3 47.1 48.1 49.1 50.1 51.1 52.1 52.2 53.1 54.1
|Simon Lloyd Re: Paste Method of worksheet class failed?? Why not add a File? Providing a file for your particular application will not only get you your answer quicker but will better illustrate your problem, usually when we can see your data (it can be dummy data but must be of the same type) and your structure it is far easier for us to give you a tailored, workable answer to your query :) |MWhiteDesigns Re: Paste Method of worksheet class failed?? I'm sorry, the new error message with your code is " Object Doesn't support this property or method". I would upload butThe file is 200MB. In addition, the firewall here prevents me from uploading anything, it just sits there. But here is something i noticed. If the copy selection is small (say for instance this whole paragraph), it pastes fine with no error. But it pastes only in column a. If i copy multple cells, say a1,b1,c1, then try to paste, i receive the error. I just need to paste what ive copied manually from another workbook (A:BK) and paste it in this sheet starting at A1. |_Mordred_ Re: Paste Method of worksheet class failed?? If you can't provide the workbook then perhaps you can provide the code that actually makes the copy. |MWhiteDesigns Re: Paste Method of worksheet class failed?? Hey Mordred, THere is no code to copy. I do it manually right now. I literally open up the other workbook, highlight columns A:BK and press Control+C. Then I go to this workbook that contains the code, and would like to click a command button to have what i just copied pasted into the sheet, (along with the other commands associated with it in the macro). |_Mordred_ Re: Paste Method of worksheet class failed?? From what I can tell, the line VBA 코드 : Columns("A:BK"). ClearContents is deselecting the copy range. Try clearing the contents before copying. |_Mordred_ Re: Paste Method of worksheet class failed?? Well it's definitely the clearcontents that is throwing the paste code. |MWhiteDesigns Re: Paste Method of worksheet class failed?? Ahh, it does work without clearcontents. I was trying to create as few steps as possible. I guess ill just create a macro to clear contents, then ill have to copy and paste :/ THanks as always. Powered by vBulletin® Version 3.8.6 Copyright ©2000 - 2012, Jelsoft Enterprises Ltd. SEO by vBSEO No part of this board, functionality or creatives may be copied or reproduced either in part or full without the express permission of The Code Cage Team. Copyright ? Simon Lloyd 2008 - 2012 We are not associated with nor employed by Microsoft in any way, we simply provide resources! All MS office icons are registered trademarks of the application they represent and are used with permission from Microsoft
1.1 2.1 3.1 4.1 5.1 6.1 7.1 8.1 9.1 10.1
Prijevodi podržava vBET 3.5.4 Powered by vBulletin ® Verzija 3.8.6 Copyright © 2000 - 2012, Jelsoft Enterprises Ltd SEO by vBSEO Predložak-Promjene koje TMS Niti jedan dio ovog odbora, funkcionalnosti i oglasi mogu se kopirati ili reproducirati ili djelomično ili u cijelosti bez izričitog dopuštenja tima Code Cage. Copyright © Simon Lloyd 2008 - 2012 Mi nisu povezani s niti zaposlen od strane Microsofta na bilo koji način, mi jednostavno osigurati sredstva! Svi MS office ikone su registrirani zaštitni znaci primjeni oni predstavljaju i koriste s dozvolom iz Microsofta