Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to create a rectangle on an Excel sheet witht the
following code. It fails with: "the specified value is out of range" I am running VB6 and Excel 2000 on a Windows XP pro PC. Thanks, Yagil === Dim MyXl As Excel.Application Sub main() Dim uiSheet1 As Worksheet Dim uiRectangle1 As Shape Set MyXl = CreateObject("excel.application") MyXl.Workbooks.Add Set uiSheet1 = Sheets.Add Set uiRectangle1 = uiSheet1.Shapes.AddShape(msoShapeRectangle, _ 10, 10, 100, 100) 'error: the specified value is out of range End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 97 keeps changing dimensions of autoshape rectangle | Excel Discussion (Misc queries) | |||
Excel - xy plot fill plotted rectangle | Charts and Charting in Excel | |||
How do i delete a saved rectangle in excel? | Excel Worksheet Functions | |||
How can cells be changed from rectangle to triangle in Excel? | Excel Discussion (Misc queries) | |||
Copy Rectangle Object From One Sheet To Another | Excel Discussion (Misc queries) |