split the code while argument is not affected

Your functions are not connected to each other, nor are they currently open to feeding parameters one to another.

Please Login or Register  to view this content.

In this function you are setting abc = to p1 +p2, but in the code above that in the function there is no code to give values to P1 or P2. So you are adding 0 + 0. You'll need to use INDEX100 to resolve p1 & P2 first.

I've merged that into one function that would appear to do the correct thing:

Please Login or Register  to view this content.

I'm assuming the lines in red will actually be removed and you will use the function to feed in the 4 parameters via cell reference.

How long was the procedure too large?

When creating a function, the parameters in the () denote the values that will be used in the function. When calling that function from another function, be sure to insert those parameters into the call, the same way you fill out a formula's parameters as you enter it into a cell.


In your original code above, the INDEX100 could be used to bring back a single result. But it looks like you need results to resolve the values of P1 and P2. I would suggest creating functions for those.

Here's a very simple example of what I mean. Here I've created a GetP1 and a GetP2 function, within those functions you can do whatever routines you need, but the end result is a single value fed back as the result of GetP1. In the main macro, that result is stored into a variable and used as needed.

Please Login or Register  to view this content.

my code is over 64 kb in a single function without code splitting,that why the error pop out.

that what i am looking for,thank you very much.