Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collection Problems
I am trying to add objects to a collection. The objects are type PolyPoint
(class). I am getting an error in the StorePoint line that Object doesn't support this property or method. Sub PanelMaker() Dim areaNum As Long areaNum = Sheets("Chart Plot Data").Range("a" & Cells(Rows.Count, 1).End(xlUp).Row).End(xlUp).Row For sect = 1 To areaNum For Each Cell In Sheets("Charts").Range("A1:A" & Cells(Rows.Count, 1).End(xlUp).Row) Set newP = New PolyPoint With newP .PointKey = Cell.Row .x = Cell.Value .y = Cell.Offset(0, 1).Value End With StorePoint (newP) Next Next sect End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems returning Collection object | Excel Programming | |||
Collection | Excel Programming | |||
Collection Class problems | Excel Programming | |||
2 Collection questions | Excel Programming | |||
Is a Collection the best option? | Excel Programming |