L
LucaP
In Excel 2003 it was possible to set a reference to a cell to show the value
of that cell in a grouped shape:
WorksheetA.Shapes("ABC").GroupItems("ABC_DEF").Formula = "=" &
WorksheetB.Name & "!" & WorksheetB.Cells(1, 1).Address(RowAbsolute:=False,
ColumnAbsolute:=False)
How is this done in Excel 2007?
Thanks
of that cell in a grouped shape:
WorksheetA.Shapes("ABC").GroupItems("ABC_DEF").Formula = "=" &
WorksheetB.Name & "!" & WorksheetB.Cells(1, 1).Address(RowAbsolute:=False,
ColumnAbsolute:=False)
How is this done in Excel 2007?
Thanks