| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - Copy range of cells based on Combobox Selection
You can copy the values very quickly with code like
Worksheets("Sheet1").Range("A1:A10").Copy _ Destination:=Worksheets("Sheet2").Range("A1") I'm not sure how your combobox fits in to this. You'll need to supply more details. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Excel-erate2004 " wrote in message ... Based on a user selection in a combo box, Is it possible to copy a range of cells from sheet1 and move them to another sheet2 Not really sure how to tackle this? Thanks for any help I can get, Greatly appreciated! --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 VBA Range selection based on system date | Excel Discussion (Misc queries) | |||
| fill combobox depending on selection from another combobox | Excel Discussion (Misc queries) | |||
| Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
| How do I copy a LARGE selection of cells from Excel to powerpoint? | Excel Discussion (Misc queries) | |||
| Syntax - Add Range Name based on Selection | Excel Programming | |||
Threaded Mode
