View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rolf Marvin Bøe Lindgren Rolf Marvin Bøe Lindgren is offline
external usenet poster
 
Posts: 10
Default [Q] msoShapeRectangle: variable not defined

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/