create a subset range in a VBA UDF

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

How within a user-defined function can I create a new
range? In other words, the input is a range and I need
to take each cell in that range and perform a function on
it (min(0,each cell's value)) that I can then calculate
the mean / standard deviation and other statistics on
within the user-defined function.

Thank you.
 
You must log in or register to reply here.

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

Similar Threads

VBA set thick borders around non empty cells in range 0
Excel VBA 1
Create range in udf 1
UDF Frustration - Won't Update 3
sumproduct in UDF 7
UDF Looks for Named Range Not Function 2
Workaround for Excel 2002/2003 UDFs recalculating and changing cel 9
Range Arguments 1

Back
Top