| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy range from one open workbook's worksheet to another.
Check to see if a workbook entitled "All_to_One...." is open.
("..." represents other miscellaneous wording). If open, select 1st worksheet in this workbook. (Will only be one worksheet in workbook.) Copy this range. Range("a4:f4").Select Range(Selection, Selection.End(xlDown)).Select Go to workbook entitled "Apples and oranges" Go to sheet "blueberries" Paste at range a4:f4. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can Excel list all of a workbook's worksheets on a worksheet? | Excel Worksheet Functions | |||
| Copy & paste cells fr open worksheet then close the worksheet | Excel Programming | |||
| select open webpage, copy information to open worksheet | Excel Programming | |||
| Copy from different workbook's worksheet into a single worksheet... | Excel Discussion (Misc queries) | |||
| Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming | |||
Threaded Mode
