Hi super Excel users
I have one more questions for you today.
Hope you can help me out on this one.
The essence of my problem is:
I have an Array which contain 200 to 300 numbers, (in one dimension only)
Then this Array can contain one or more zeros and I want to get the index.numbers of those zeros.
If the Array do not contain any exact zeros it might contain one or more numbers that are pretty close to zero and have zero slope (saddle points). If the Array doesn't contain any exact zeros I want to get the index numbers of those points being close to zero and at the same time have zero slope.
Is it possible to do this in pure VBA in an easy way without writing all the numbers in the Array to a range in Excel ?
Hope one of you nerds out there can help me out on this one.
Regards
NCO
Denmark
All for today
I have one more questions for you today.
Hope you can help me out on this one.
The essence of my problem is:
I have an Array which contain 200 to 300 numbers, (in one dimension only)
Then this Array can contain one or more zeros and I want to get the index.numbers of those zeros.
If the Array do not contain any exact zeros it might contain one or more numbers that are pretty close to zero and have zero slope (saddle points). If the Array doesn't contain any exact zeros I want to get the index numbers of those points being close to zero and at the same time have zero slope.
Is it possible to do this in pure VBA in an easy way without writing all the numbers in the Array to a range in Excel ?
Hope one of you nerds out there can help me out on this one.
Regards
NCO
Denmark
All for today