Replace ARRAY formula with VBA code

Hello

I use this ARRAY formula in a sheet and then i get the result in a textbox of a userform.

Formula:

Please Login or Register  to view this content.

I am wondering how can i replace this formula with a macro-code as my application started to be slow, using this. Let's say that the value of cell ae2, I'll get from textbox1 and the result should be in textbox2.

Any idea for this?

Hi,

It will be slow because you are covering 29000 + rows. Is that necessary?

Unfortunately yes.

That's why i thought that a macro will works faster.

Hi,

Can you explain what you are trying to do. There may well be a non array function solution.
Attach a small example workbook along with some notes as to what you're attempting to do and manually add some calculated results.

Thank you for looking at this.

I prepared a small example to see what i do.

Hi,

You've succesfully uploaded the workbook but have not said what the aim is and added some manually calculated results - as asked for.
As it stands I have no idea what your process is supposed to achieve apart from making something faster, but of course being a small file it will not be slow anyway.

I need to know exactly what you DO, i.e. data entry, values and results.

Give a try to this Maria. It's gives the results that you want(i added reults for amounts in textbox2) in your example sheet. I hope-think that will be faster(than the way that you already have) in your original workbook.

Please Login or Register  to view this content.

Thank you again Mr Foti.Excellent! More than 50% faster than the way that i used.