Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to create a loop to count how many times a date function I have
written is performed before a criteria is met. I am receiving a ByRef error, and do no know how to fix it. Here is the code: Public Function myfunc(testdate, maturitydate) counter = 0 Do While maturitydate testdate testdate = nextcdate(testdate) counter = counter + 1 Loop myfunc = counter End Function Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Public function in Personal.xls | Excel Programming | |||
Using A Public Function / | Excel Worksheet Functions | |||
public function | Excel Programming | |||
Make Function Public | Excel Programming | |||
Public Function | Excel Discussion (Misc queries) |