to call subfunction from a function
 

Please let me know how I can call subfunction from a function

With thanks
Pol

to call subfunction from a function
 

=AVERAGE(SUM(A1:A20),SUM(D3:D4))
--
Gary''s Student - gsnu200807

to call subfunction from a function
 

Thanks for the reply
I have a two function

1. itemprice()
2. sizeonly()

I want to call sizeonly() from itemprice

sub itemprice
Here I have to call sizeonly()
end sub

with thanks
Pol



"Gary''s Student" wrote:

=AVERAGE(SUM(A1:A20),SUM(D3:D4))
--
Gary''s Student - gsnu200807

to call subfunction from a function
 

Hi

Sub Itemprice()
some code
call sizeonly
continue with more code
End sub

When sizeonly finishes, it will return to the next line in the calling sub.

--
Regards
Roger Govier

"pol" wrote in message
...
Thanks for the reply
I have a two function

1. itemprice()
2. sizeonly()

I want to call sizeonly() from itemprice

sub itemprice
Here I have to call sizeonly()
end sub

with thanks
Pol



"Gary''s Student" wrote:

=AVERAGE(SUM(A1:A20),SUM(D3:D4))
--
Gary''s Student - gsnu200807

to call subfunction from a function
 

thanks


"Roger Govier" wrote:

Hi

Sub Itemprice()
some code
call sizeonly
continue with more code
End sub

When sizeonly finishes, it will return to the next line in the calling sub.

--
Regards
Roger Govier

"pol" wrote in message
...
Thanks for the reply
I have a two function

1. itemprice()
2. sizeonly()

I want to call sizeonly() from itemprice

sub itemprice
Here I have to call sizeonly()
end sub

with thanks
Pol



"Gary''s Student" wrote:

=AVERAGE(SUM(A1:A20),SUM(D3:D4))
--
Gary''s Student - gsnu200807