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.

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.

You've got some responses to your multi-post in .misc. Pl don't multi-post.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jacky Hope" wrote in message
...
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.