Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
pol pol is offline
external usenet poster
 
Posts: 129
Default to call subfunction from a function

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

With thanks
Pol
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default to call subfunction from a function

=AVERAGE(SUM(A1:A20),SUM(D3:D4))
--
Gary''s Student - gsnu200807
  #3   Report Post  
Posted to microsoft.public.excel.misc
pol pol is offline
external usenet poster
 
Posts: 129
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default 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


  #5   Report Post  
Posted to microsoft.public.excel.misc
pol pol is offline
external usenet poster
 
Posts: 129
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a do not call function? pokdbz Excel Discussion (Misc queries) 2 December 27th 07 04:00 PM
Don't know what to call the type of function I need Kasey Excel Worksheet Functions 4 December 8th 06 04:47 PM
how can i call sub or function in vba code xxx Excel Discussion (Misc queries) 3 June 28th 06 11:47 AM
Custom Function Call Bill Martin -- (Remove NOSPAM from address) Excel Discussion (Misc queries) 5 September 6th 05 06:14 PM
how i can call the function reneabesmer Excel Worksheet Functions 2 May 2nd 05 12:13 PM


All times are GMT +1. The time now is 01:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"