Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy structure chart
Hello,
I have the following code which i think is close but not close enough. I want to get the value from a cell in one workbook, look up that value which will be a tab name in another workbook, find a structure chart in that sheet and paste it back in to the sheet I started with. This is what I have: Dim RegionName As String RegionName = Sheets("Qry_Basic_Information").Range("A2").Value Windows("My Pack (Structure Charts).xls").Activate Sheets(RegionName).Select For Each myshape In ActiveSheet.Shapes If myshape.Type = 12 Then myshape.Copy Next myshape Windows("My Pack.xls").Activate Range("B6").Select ActiveSheet.Paste Can anyone point me in the right direction? Many thanks in advance, Martin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy chart formatting and chart templates in Excel 2007 | Charts and Charting in Excel | |||
Format and Structure to a Line Chart | Charts and Charting in Excel | |||
How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
if structure help | Excel Programming | |||
Structure of If...Else in VBA | Excel Programming |