Thread: How to enter a formula (cell reference) to a shape instead of text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LucaP LucaP is offline
external usenet poster
  
Posts: 2
Default How to enter a formula (cell reference) to a shape instead of text
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").For mula = "=" &
WorksheetB.Name & "!" & WorksheetB.Cells(1, 1).Address(RowAbsolute:=False,
ColumnAbsolute:=False)

How is this done in Excel 2007?

Thanks
Reply With QuoteReply With Quote