Enter Keywords:
1 - 10 of 233(0 seconds)
Sort By:
 
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...
Zones: MS ExcelDate Answered: 12/22/2003 Rating: 8.2 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......
Zones: MS ExcelDate Answered: 11/24/2003 Rating: 9.0 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...
Zones: MS SQL ServerDate Answered: 04/20/2004 Rating: 7.6 Views: 0
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 ...
Zones: MS SQL ServerDate Answered: 07/07/2004 Rating: 9.0 Views: 0
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...
Zones: MS ExcelDate Answered: 12/13/2004 Rating: 6.8 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...
Zones: MS ExcelDate Answered: 10/03/2004 Rating: 9.4 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,...
Zones: ASP.Net ProgrammingDate Answered: 12/29/2005 Rating: 9.6 Views: 0
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...
Zones: MS SQL ServerDate Answered: 08/18/2006 Rating: 9.4 Views: 0
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...
Zones: MS SQL ServerDate Answered: 10/30/2006 Rating: 8.6 Views: 0
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...
Zones: MS SQL ServerDate Answered: 11/08/2006 Rating: 9.0 Views: 0