Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Drop Down Lists
I am trying to copy data from one worksheet into an updated worksheet.
One of the pages contains cells with drop down box selections. I'm trying to copy the data with the macro below but it's getting hung up on the ActiveSheet.Shapes("Drop Down 50").Select Selection.Copy line. Can anyone help? Windows("BFP_OPXBUDGET_V452_15NOV05.xls").Activate Range("B30:B37").Select ActiveSheet.Shapes("Drop Down 50").Select Selection.Copy Windows("BFP_OPXBUDGET_V454_20NOV05.xls").Activate Range("B30").Select ActiveSheet.Paste |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Drop Down Lists
Assuming hung up means that you get an error. If the error is subscript out
of range, then you don't have a shape with the name "Drop Down 50" -- Regards, Tom Ogilvy "David" wrote in message ... I am trying to copy data from one worksheet into an updated worksheet. One of the pages contains cells with drop down box selections. I'm trying to copy the data with the macro below but it's getting hung up on the ActiveSheet.Shapes("Drop Down 50").Select Selection.Copy line. Can anyone help? Windows("BFP_OPXBUDGET_V452_15NOV05.xls").Activate Range("B30:B37").Select ActiveSheet.Shapes("Drop Down 50").Select Selection.Copy Windows("BFP_OPXBUDGET_V454_20NOV05.xls").Activate Range("B30").Select ActiveSheet.Paste |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Drop Down Lists
I used the Record Macro function to get the code. When I copy and paste
manually it works. Anything else you can offer? "Tom Ogilvy" wrote: Assuming hung up means that you get an error. If the error is subscript out of range, then you don't have a shape with the name "Drop Down 50" -- Regards, Tom Ogilvy "David" wrote in message ... I am trying to copy data from one worksheet into an updated worksheet. One of the pages contains cells with drop down box selections. I'm trying to copy the data with the macro below but it's getting hung up on the ActiveSheet.Shapes("Drop Down 50").Select Selection.Copy line. Can anyone help? Windows("BFP_OPXBUDGET_V452_15NOV05.xls").Activate Range("B30:B37").Select ActiveSheet.Shapes("Drop Down 50").Select Selection.Copy Windows("BFP_OPXBUDGET_V454_20NOV05.xls").Activate Range("B30").Select ActiveSheet.Paste |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Drop Down Lists
Someone had made the range of data into a "list" that could be sorted. I
removed this and it works normally. Thanks! "Tom Ogilvy" wrote: Assuming hung up means that you get an error. If the error is subscript out of range, then you don't have a shape with the name "Drop Down 50" -- Regards, Tom Ogilvy "David" wrote in message ... I am trying to copy data from one worksheet into an updated worksheet. One of the pages contains cells with drop down box selections. I'm trying to copy the data with the macro below but it's getting hung up on the ActiveSheet.Shapes("Drop Down 50").Select Selection.Copy line. Can anyone help? Windows("BFP_OPXBUDGET_V452_15NOV05.xls").Activate Range("B30:B37").Select ActiveSheet.Shapes("Drop Down 50").Select Selection.Copy Windows("BFP_OPXBUDGET_V454_20NOV05.xls").Activate Range("B30").Select ActiveSheet.Paste |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists from multiple source lists | Excel Worksheet Functions | |||
Copying named lists used in drop downs from one workbook to anothe | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
Copying Cells with Drop Down Lists | New Users to Excel | |||
Copying Cells with Drop Down Lists | Excel Worksheet Functions |