Function value always the same

[Thomas]

I have written a function, SummaryStatistics(), that needs to operate on
values in a column. Part of the function determines which column it is in.
Then it uses that as part of a range to tick through the values in that
column, row by row and produce a result.

Problem is that when I place =SummaryStatistics() in multiple cells they all
display the same result based on the column where the cursor happens to be.

Is there a way around this?

Thanks.

Thomas

 

[Frank Kabel]

Hi Thomas
best to use a cell reference as parameter of your function. Don't use
constructs like activecell or Selection within such a user defined
function.

You may post the relevant part of your code for amendment