ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Add In vs functions (https://www.excelbanter.com/excel-worksheet-functions/248131-add-vs-functions.html)

Schedule Guy[_2_]

Add In vs functions
 
Is there a quick way to change an Add-in to a manipulable function? I want
to perform a "conditional sum" in several cells, using remote cell values as
criteria and am tired of going through the whole routine each time and seeing
it crash at the end.

Jacob Skaria

Add In vs functions
 
Maybe someone here could help with an alternative formula or a user-defined
function. if you can explain the requirement..

'Check out the below link.
http://www.mcgimpsey.com/excel/fileandvbapwords.html

If this post helps click Yes
---------------
Jacob Skaria


"Schedule Guy" wrote:

Is there a quick way to change an Add-in to a manipulable function? I want
to perform a "conditional sum" in several cells, using remote cell values as
criteria and am tired of going through the whole routine each time and seeing
it crash at the end.


Gord Dibben

Add In vs functions
 
An Add-in is a workbook, not a function.

Do you have a "Function" in the add-in that you want to use?

Provide more detail on what you want to get done as far as "conditional sum"

Which "whole routine" is crashing?


Gord Dibben MS Excel MVP


On Tue, 10 Nov 2009 19:26:18 -0800, Schedule Guy
wrote:

Is there a quick way to change an Add-in to a manipulable function? I want
to perform a "conditional sum" in several cells, using remote cell values as
criteria and am tired of going through the whole routine each time and seeing
it crash at the end.




All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com