View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
suomi suomi is offline
external usenet poster
 
Posts: 4
Default Possible to call a procedure inside a function?

Hello group,
How can I call a procedure in a function? Is this allowed or do I have
to change the function into a procedure? To simplify, problem looks
like this:

Sub WriteHere(What As Integer)
ActiveCell.Offset(1, 0).Value = What
End Sub

Function Count(What As Integer)
Call WriteHere(What)
Count = What ^ 2
End Function

The argument from function is not passed to the procedure. The function
is not calculated.
Can you advise on this? Cheers