Thread
:
built-in function doesn't work properly
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tushar Mehta
external usenet poster
Posts: 126
built-in function doesn't work properly
You should pass as arguments *all* ranges you use in the function. In
your case, you are not passing the range named TodayDate.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
In article ,
says...
This simple Function doesn't update the result.... I have to edit the cell to
calculate new result. The easiest way i found is to prees 'F2' and 'Enter'
for each cell that have this function...
Thanks for any help
Function CupaoActual(RangeDatasCupao As Range) As Byte
Dim j As Byte
For j = 1 To RangeDatasCupao.Count
If RangeDatasCupao(1, j) Range("TodayDate") Then
CupaoActual = j - 1
Exit Function
End If
Next
End Function
Reply With Quote
Tushar Mehta
View Public Profile
Find all posts by Tushar Mehta