Thread: How can I build a Excel Function that acts like those built-in
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Manville Bill Manville is offline
external usenet poster
  
Posts: 473
Default How can I build a Excel Function that acts like those built-in
Wlh wrote:

Can somebody tell me how to pass/get the proper array item value?


case "Range"
If T.Cells.Count1 Then
MyFunc =MoreComplexFunc(T.Cells(Application.Caller.Row - T.Row +
1, 1))
Else
MyFunc=MoreComplexFunc(t.Value)
End If



Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup

Reply With QuoteReply With Quote