User Defined function question. for a sigma function

**thisisaMJ** · 01-25-2018, 09:23 AM

Hi, I am trying to define a Sigma summation function, but the below code is not working, seems like I cant use indirect function in the User Defined function, below is the code:

Please Login or Register  to view this content.

I think the red part is where the problem lies, as I am trying to indirect cells referring to the value of i.

any one can help this out?

Thanks!

**Norie** · 01-25-2018, 09:36 AM

Try changing Indirect to Range.

PS When posting code can you please use CODE tags?

**thisisaMJ** · 01-25-2018, 09:52 AM

Originally Posted by Norie

Try changing Indirect to Range.

PS When posting code can you please use CODE tags?

Hi Norie, really thanks for the help!

it worked!

and I have edited my original post.

For anyone encounters the same problem, here is the working code:

Please Login or Register  to view this content.

User Defined function question. for a sigma function

LinkBack

Thread Tools

Rate This Thread

Display

User Defined function question. for a sigma function

Re: User Defined function question. for a sigma function

Re: User Defined function question. for a sigma function

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Usage of standard functions into custom function (or user defined function)

COUNTIF/COUNTIFS function + nested user-defined function

[SOLVED] User defined function returns an error on a standard function used in it.

User-defined Function question

[SOLVED] Excel - User Defined Function Error: This function takes no argume

Question-user defined function

Need to open the Function Arguments window from VBA for a user defined function.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions