Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA formula
Hi all,
I wish to write a Excel formula (VB function) that would take a source range, and a destination cell as parameters. The function would do some calculations and would return the result. But would also write some additional text to the destination cell. I am not sure what I am doing wrong, could someone please help me .... I have written a small function similar to the one that I actually need. Function test(src As Variant, dest As Variant) as Variant test = "100" Range(dest).Formula = "=sum(" & Range(src).Address & ")" End Function Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |