Function value always the same

  • Thread starter Thread starter Thomas
  • Start date Start date
T

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
 
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
 
Back
Top