custom function

S

Shoe Box

Hi

I would like to create a function. My question is how to select a range of
cells as input.
For example, the 'sum' fucntion work like this =sum(A1:A9), it will
calculate the sum of selected cells.
If i want to create the same function like 'sum', what's the coding like?

I asked this question because i want to know how can i get a range of input
and know how to determine which is the last cells.

pls advice
SB
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top