LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Unable to assign values to Class Properties

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
unable to set the values property of the series class BHatMJ Excel Discussion (Misc queries) 4 July 10th 09 03:46 PM
Unable to set the Values property of the Series class rafael garcia Charts and Charting in Excel 1 September 25th 06 04:31 PM
Unable to set the Values propert of series class smudge75 Excel Programming 0 August 16th 06 03:00 PM
Unable to set the xvalues (or values) property of the series class Kate Excel Programming 1 May 5th 05 02:13 PM


All times are GMT +1. The time now is 03:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"