I have a UDF that needs to be replaced with a built in equation (macro enabled workbooks cannot be saved on this server).
I wrote a formulla to do this but the result has long equations that cannot be passesed as strings so I had to write an assembler into the mix.
I could have sworn I had tested it and it was working but I am running it now and it isn't doing anything.
This is the assembler script is:M and T are arrays of strings that contain multiplied addresses (the end formulla basically lets me use non-continuouse ranges in sumproduct)Please Login or Register to view this content.
the code executes fine no errors pop up but at the end of it the formulla in the cell is still "{=SUM(A2)/SUM(B3)}". I have stepped through it and when I get to this step all the strings are fine and the refferences are correct, VBA just isnt replacing "A2" with M(I) & "A2".
any Ideas what is causing this?
I will try again when I get back in work on monday and see if the function is working again (which I am sure it was, I have some files where this has been run and the formulla is fine on them).
I am sure someone will ask for the full module (someone always does, thinking it is rellevent) so here it is:Please Login or Register to view this content.
Bookmarks