Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using Visual Basic 6 (not VBA) and Excel 2000
I have graphics and text grouped together on a worksheet. I need to update the text. Trying to ungroup in the follow code I get run time erro 1004 "Application- defined or object-defined error" from Excel back to VB. For Each xlWorkSheet In xlWorkbook.Sheets xlWorkSheet.Select For I = 1 To xlWorkSheet.Shapes.Count Shape = xlWorkSheet.Shapes(I) If Shape.Type = msoGroup Then Shape.Select Shape.Ungroup <-- crash and burn here. End if Next I Next xlWorkSheet help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel document with shapes on it but the shapes do not print | Excel Worksheet Functions | |||
Ungrouping | Excel Discussion (Misc queries) | |||
Naming Auto Shapes and Creating new Shapes | Excel Discussion (Misc queries) | |||
When drawing shapes in excel the shapes keep disappearing | Excel Discussion (Misc queries) | |||
Ungrouping using vb | Excel Programming |