Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel formulae to VBA functions
Hi all, I have the following excel formulae in Cell T10:
" =If (and(or(J10="",istext(J10)),K10=""),"",Sum(K10:S10 )) " which i would like to convert to a VBA function. The function would then be copied down 200 rows in Column T. Your help appreciated. Using XP with XL2003 still newbie but enjoying. Rgds KZ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please suggest any formulae / functions | Excel Discussion (Misc queries) | |||
Removing all formulae/functions/codes from previously saved worksh | Excel Discussion (Misc queries) | |||
Two questions on worksheet protection and hiding formulae/ functions | Excel Programming | |||
Nested functions in conditional formatting formulae | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions |