more than 250 word in cell with fuction

[Guest]

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.

 

[Max]

You've got some responses to your multi-post in .misc. Pl don't multi-post.

 

[Guest]

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