Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy a named range from an installed add-in while in anothter work
Do it without selecting.
If the code is in the addin: Thisworkbook.worksheets("sheet9999").range("CEMerg eDataHeader").copy _ destination:=activesheet.range("a1") or be specific: Workbooks("myaddin.xla").worksheets("sheet9999") _ .range("CEMergeDataHeader").copy _ destination:=workbooks("someotherworkbook.xls") _ .worksheets("sheet8888").range("a1") Seth Schwarm wrote: Excel XP I want to copy (not paste, copy only) a named range located in an Add-In (XLA) which is installed while in any other workbook file. The Add-In I am referencing creates a new menu in Excel at Open of any workbook. To run the subprocedure to copy the range - I select a command from the menu which is created at Open as a result of the Add-In I have mentioned. I created a new macro to see what the VBA code would look like and this is what it looks like: Application.Goto Reference:="CEMergeDataHeader" Selection.Copy When I select the command in the menu created at Open - I receive Error 1004. Please help. Thank you - Seth -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cells from named range | Excel Discussion (Misc queries) | |||
Copy cells from named range | Excel Discussion (Misc queries) | |||
Can't copy named range | Excel Programming | |||
copy named range to powerpoint | Excel Worksheet Functions | |||
copy named range | Excel Programming |