Thread: Excel - Copy range of cells based on Combobox Selection
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default 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/



Reply With QuoteReply With Quote