I'm fairly new to drawing objects in Excel from VBA, and have stumbled
on a peculiar issue. the variable msoShapeRectangle, which apprarently
is suppoed to be predefined, is not declared.
I've recorded the following from Excel:
ActiveSheet.Shapes.AddShape(msoShapeRectangle, 303#, 48#, 255#,250.5)._
Select
execution is aborted with the error message "msoShapeRectangle :
Variable not defined".
any clues?
thank you,
--
Rolf Lindgren
http://www.roffe.com/