Thread: Editing text in text box grouped within a trapezoid
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
DM Unseen DM Unseen is offline
external usenet poster
  
Posts: 233
Default Editing text in text box grouped within a trapezoid
I'm back!

I realised a typo slipped in (but weas not able to correct it).

It should be:

shp.DrawingObjects.Formula = Range("A1").Offset(0, i).Address

The fotmula property only accepts an cell/range address.

Hereby finishing this discussion properly;)

DM Unseen

Reply With QuoteReply With Quote