more than 250 word in cell with fuction

more than 250 word in cell with fuction

Post by SmFja3kgSG » Fri, 16 Feb 2007 13:59:07


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

Post by SmFja3kgSG » Fri, 16 Feb 2007 14:00:13

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

Post by Max » Fri, 16 Feb 2007 23:53:36

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

Post by Sm9lb » Fri, 16 Feb 2007 23:54:40

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