Leith Ross Wrote:
Hello Dreamz,

The first line of Calculate should should look like this...

Public Sub Calulate(Byval chDep, ByVal chTr, Byval chHum)

If you have more varaiables add them to the list the same way. This
delaces the variables for you, so you don't need to have Dim statements
for each.

Sincerely,
Leith Ross
thank you for your help. unfortunately, i get an error this time.

Compile error: Argument not optional

what went wrong?


--
dreamz
------------------------------------------------------------------------
dreamz's Profile: http://www.excelforum.com/member.php...o&userid=26462
View this thread: http://www.excelforum.com/showthread...hreadid=480621