| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Round(cell,0) after the Fact
WOWWWWWW - to all three of you guys !!
Thanks, Jim "Jan Karel Pieterse" wrote: Hi Jim, In my sheet All formulas are strictly =Sum() Is there a MACRO (VBA) that can CHANGE All = Sum()'s formulas to =Round(Sum(),0) at once ? If so, could someone share code. I've been trying now for an hour, but without success including a google search. Check this page: http://www.jkp-ads.com/Articles/FormulaWrapper00.htm Use the code showed in there, but change this line of code: sFormulaTemplate = "=IF(ISERROR(_form_),"""",_form_)" to: sFormulaTemplate = "=SUM(_form_)" Regards, Jan Karel Pieterse Excel MVP http://www.jkp-ads.com Member of: Professional Office Developer Association www.proofficedev.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fact() | Excel Worksheet Functions | |||
| Determing the SQL Datasource After the Fact | Excel Discussion (Misc queries) | |||
| Factorial (like =FACT) function? | Excel Worksheet Functions | |||
| Adding a date stamp to each cell in column - after the fact | Excel Discussion (Misc queries) | |||
| Shortcut Ket after the fact | Excel Programming | |||
Threaded Mode
