Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
msoShapeRectangle | Excel Programming | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
[Q] msoShapeRectangle: variable not defined | Excel Programming | |||
[Q] msoShapeRectangle: variable not defined | Excel Programming | |||
[Q] msoShapeRectangle: variable not defined | Excel Programming |