[Q] msoShapeRectangle: variable not defined

  • Thread starter Rolf Marvin Bøe Lindgren
  • Start date
R

Rolf Marvin Bøe Lindgren

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,
 
Top