Option Explicit and what looks like an undeclared variable despite no error reported

Hi

I hope someone can help me. I've inherited some VBA code and I'm trying to understand it.

I have 3 separate functions as follows:-

Function PDelay#(TrafficC#, Servers%)
Defined as (1.33, ????
Dim Part1#, Part2#, CommonPart#, Counter%

Function SLevel#(Calls#, AHT#, Period%, SLO%, Servers%)
Defined as 8, 300, 1800, 20, ????
Dim Traffic#, PZero#

Function Staffing%(Calls#, AHT#, Period%, SLO%, SLA#, LimOccupancy#)
Defind as 8, 300, 1800, 20, 0.8, 0.85
Dim Traffic#, SrvcLvl#

I've managed to follow the variables listed above with the staffing% function being used as a formula in cells. The others functions are not. I can't seem to find a definition of the servers% variable. There's nothing in the rest of the code defining servers# and I'm completely stuck. If it's easier to publish the whole code I can do so. Does it have to be defined as per the Dim statement? I'm completely lost.

Any help would be appreciated.

Thanks in advanced.

Hi

Thanks for responding. The Defined as was me putting a number to the variable. Just ignore it. Code below for all 3 funtions:-

Please Login or Register  to view this content.

Hope you can help.

Thanks

Thanks shg

I hear what you're saying. This is me trying to take over code maintenance from someone else. Pure nightmare. Especially when you haven't dealt with Option Explicit before. Thanks for the restructure.

Thanks protonLeah. Lot clearer now.

And with shg's new layout it makes it a lot more familiar. I assume the % and # were the old declarations which I've never seen before.

Thanks again.