View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Linda Edlund Linda Edlund is offline
external usenet poster
 
Posts: 11
Default msoShapeRectangle -- Variable not defined ???

Hello,
I'm receiving the following error, in the code which already has worked

Set shp = ActiveSheet.Shapes.AddShape(msoShapeRectangle, 10, 10, 20, 20)

With shp
.Name = "abc"
.Fill.ForeColor.SchemeColor = 59
.Line.Weight = 0.25
.Line.ForeColor.SchemeColor = 22
End With

ERROR:
Compile Error: Variable not defined

and it's highlights < msoShapeRectangle ??????


Can anyone tell me how to correct the situation?

Any help will be appreciated

Linda