When a formul gets thatt large it best to convert to a function

end the code under the tools menu under macro visual basic editor


Function ABC()


ABC=1

End Function


In the workbook put =ABC()
the number 1 will be returned.

Write the macro in small steps to make it easierr to run

Instead of A = 1 * 2 * 3
A = 1
B = A * 2
C = B * 3

You can use the debug menu in the Visual Basic editor to step through the code


You can have
function ABC(A, B, c)

the call it with
=ABC(D2, E4, F7) where D2, E4 and F7 are cell numbers



"Jacky Hope" wrote:

I have very large formular which containt more than 250 letter in it.
How can we enlarge the number number of letter in functioning cell.