more than 250 word in cell with fuction
 

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.

more than 250 word in cell with fuction
 

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.

more than 250 word in cell with fuction
 

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.