User has a large excel sheet that takes to long to calculate... common problem, i know.
A lot of the calculations are vertical lookups. I would like to replace these by a UDF that will only do t...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 12/22/2003 Grade: A Views: 0
I need to register my UDF. (i.e. Write descriptions for the arguments, add it to a category, etc.) I'm pretty sure that you can also define how you want the UDF to look when the user types it in......
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 11/24/2003 Grade: A Views: 0
How would you convert the following function in MS Access (error handling omitted) into a UDF?
Public Function fncGetReturnValue(Optional intA As Integer =1) As Currency
If IsMissing (intA) T...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20946899.html
Here's a toughie for ya. How would I go about passing a table or table name (as far as I know, has to be the latter) in as a parameter to a stored procedure or user defined function, and have that ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21050890.html
Hi,
I would like to create a UDF that find a value in a file and give back the description.
I have a file called Anag.xls with a worksheet in which there are two columns: column A Item code and...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 12/13/2004 Grade: A Views: 0
I tried to write a Public Function on the sheet code, not in a module.
Let's say the function name is MyFunc.
It doesn't work when I give a formula on the worksheet like
=MyFunc().
I get a...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/03/2004 Grade: A Views: 0
I am using the following function successfully for one part of my application:
'Function to allow records to be inserted through controls
Function InsertCallInEntry(ByVal userid As Integer,...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21677785.html
I would like to creat e a UDF that returns the last date of the month based on the inout parameter ( month)
for example, If I input 6 as the month, 06/30/2006 should return as the result.
How...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21959627.html
expert,
I need to use a Where clause many times in differnt blocks of query statement. This Where clause is alway the same one:
where QTD_ind = (SELECT CASE WHEN datepart(m, getdate()-1) = 10...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22042516.html
Thanks in advance for any assistance.
I need a function that will produce the name of the day of the week from a date (mm/dd/yyyy) pulled from a database
dbo.FunctionName(12/01/2006) as Da...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22053596.html
