Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I receive the error message that I am out of stack space. I receive this
error message on the first iteration of my loop structure which is puzzling. The errror seems to be the line where I attempt to assign a date value to a class property. In addition to receiving the error message, and the debugger stopping on line 14 below, I noticed the Activitiy.Index property on line 11 is not receiving the proper value either. The Activity.Index should have the the value of one after the assignment but its failing to do so. Any assistance is greatly appreciated. Below is the code: 01Do Until switch = False 02 If ActiveCell.Row = limit Then 03 switch = False 04 Else 05 With ActiveCell 06 If .Value <= " " Then 07 .Offset(1, 0).Activate 08 Else 09 Set Activity = New Class1 10 temp = .Address 11 Activity.Index = counter 12 Activity.BusPart = .Value 13 'MyDate = .Offset(0, 20) 14 Activity.StartTime = .Offset(0, 20) 15 VisitPlan.Add Activity 16 17 temp.Activate 18 .Offset(1, 0).Activate 19 counter = counter + 1 20 End If 21 End With 22 End If 23Loop |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
unable to set the values property of the series class | Excel Discussion (Misc queries) | |||
Unable to set the Values property of the Series class | Charts and Charting in Excel | |||
Unable to set the Values propert of series class | Excel Programming | |||
Unable to set the xvalues (or values) property of the series class | Excel Programming |