Cut And Paste Error
Contents |
Popular Forums Computer Help Computer Newbies Laptops Phones TVs & Home Theaters Networking & Wireless Windows 7 Windows 10 Cameras All Forums News Top Categories Apple Computers Crave Deals Google Internet Microsoft Mobile Photography Security Sci-Tech Tech Culture cutting paste for stainless steel Tech Industry Photo Galleries Video Forums Video Top Categories Apple Byte Carfection CNET Top cutting paste for drilling 5 CNET Update Googlicious How To Netpicks Next Big Thing News On Cars Phones Prizefight Tablets Tomorrow Daily CNET Podcasts How
Copy And Paste Error
To Top Categories Appliances Computers Gaming Home Entertainment Internet Mobile Apps Phones Photography Security Smart Home Tablets Wearable Tech Forums Speed Test Smart Home Top Categories Tour CNET Smart Home Smart Home News Smart Home
Copy And Paste Error Messages
How To Best Smart Home Devices Cars Top Categories Car Reviews Best Cars New Cars Used Cars Deals Top Categories Cheapskate Best Tech Under $50 All Deals Tech Deals Non-Tech Deals Audio Deals Cell Phone Deals Desktop Deals Laptop Deals Hard Drive & Storage Deals Printer Deals Tablet Deals Camera Deals Monitor Deals Software Deals TV Deals Web Hosting VPN Services WordPress Hosting Domain Names Download Sign In / Join Sign copy and paste error in excel In to CNET Join CNET Member Benefits My Profile Forums Sign Out US Other editions United Kingdom Australia China France Germany Japan Korea CNET en Español CNET Forums Windows Legacy OS Explorer Cut & Paste Error Windows Legacy OS forum About This ForumCNET's Forum on Windows legacy operating systems, (XP, 2000/NT, ME, & Windows 95/98) is the best source for finding help or getting troubleshooting advice from a community of experts. Discussions cover Windows 2003 Server, Windows installation, adding and removing programs, driver problems, crashes, upgrading, and other OS-related questions.Real-Time ActivityMy Tracked DiscussionsFAQsPoliciesModerators General discussion Explorer Cut & Paste Error by racsw / November 28, 2012 11:03 AM PST Hello,I have all the latest upgrades on my XP system. It is a Quad Core 2.66 GHz processor with 3 Gb of RAM, 250 GB HD, (1/3 full) and Service Pack 3.I did have a virus or trojan some time ago (2 - 3 months) which was successfully removed, and the computer has been working *almost* perfectly since. Explorer, the one that moves files around, seems to be damaged somehow. If I try to Cut and Paste a small file, or drag it, it usually will be OK. If I try to C&P (or drag) larger files or folders, it wil
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers
Copy Paste Error Windows 7
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x excel paste error too many different cell formats Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it excel copy and paste area not the same size only takes a minute: Sign up VBA Cut and Paste error up vote 3 down vote favorite I'm trying to cut the contents of cell K7 (100) and paste it into M7 using VBA (see below) but I keep getting https://www.cnet.com/forums/discussions/explorer-cut-paste-error-578943/ an error (see below). Where am I going wrong?: Sub CutPaste() Worksheets("Sheet2Test").Activate Range("K7").Select Selection.Cut Range("M7").Select Selection.Paste End Sub excel excel-vba share|improve this question edited Sep 28 '14 at 8:48 chris neilsen 30.6k63967 asked Nov 10 '12 at 16:44 Anthony 1,260164282 1 And which line are you getting the error on? –lc. Nov 10 '12 at 16:51 +1 Thanks for your reply. When I debug, I'm getting the error on the 6th line ( Selection.Paste) –Anthony Nov 11 http://stackoverflow.com/questions/13323915/vba-cut-and-paste-error '12 at 14:19 add a comment| 2 Answers 2 active oldest votes up vote 7 down vote accepted Its better to avoid Select altogether. Use this Worksheets("Sheet2Test").Range("K7").Cut Worksheets("Sheet2Test").Range("M7") share|improve this answer answered Nov 10 '12 at 21:53 chris neilsen 30.6k63967 +1 This is excellent! Concise and more efficient. Thank you! –Anthony Nov 11 '12 at 14:33 1 It works great but I'm trying to understand how this line paste the data. –Anthony Nov 11 '12 at 15:26 add a comment| up vote 7 down vote Just replace Selection.Paste for ActiveSheet.Paste , so it would be: Sub CutPaste() Worksheets("Sheet2Test").Activate Range("K7").Select Selection.Cut Range("M7").Select ActiveSheet.Paste End Sub That would do the paste as you wanted. share|improve this answer answered Nov 10 '12 at 16:55 Nelson 26.5k63857 +1 Thank you. It worked. –Anthony Nov 11 '12 at 14:25 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged excel excel-vba or ask your own question. asked 3 years ago viewed 20182 times active 2 years ago Related 0VBA Assistance needed. trying to select a range of cells, cut, move and pa
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 06 Oct 2016 09:02:16 GMT by s_hv987 (squid/3.5.20)
index The team • Delete all board cookies • All times are UTC + 1 hour [ DST ] Forum powered by phpBB © phpBB Group By any use of this Website, you agree to be bound by these Policies and Terms of Use Get OpenOffice