| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Must range be selected before a paste can be done?
Greetings! I was wondering if there is a shorter or a quicker way of
accomplishing the following: Range("A315:A999").Cut Range("A300").Select ActiveSheet.Paste Range("C315:AE999").Cut Range("C300").Select ActiveSheet.Paste I tried: Range("A315:A999").Cut Range("A300").Paste Range("C315:AE999").Cut Range("C300").Paste but the error message I obtained upon execution said something about the paste method not being supported here. Any help/advice will be greatly appreciated. May you have a blessed day. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste selected Range from Excel to Outlook with Disclaimer Statement & Signature | Excel Discussion (Misc queries) | |||
| Looping: Search Range in Multiple Selected Worksheets, Copy/Paste | Excel Programming | |||
| Paste under selected cell | Excel Discussion (Misc queries) | |||
| Context Menu, Paste Special From Selected Range | Excel Programming | |||
| How to Copy & Paste selected Range in Excel (MFC) | Excel Programming | |||
Threaded Mode
