## more than 250 word in cell with fuction

### 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

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://www.yqcomputer.com/
xdemechanik
---

### 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