Programming

SumProduct problem
Hello, I wrote a function which is using SumProduct. a is a worksheet range b is a worksheet cell c is a worksheet range Function cond_average(a, b, c) If Application.SumProduct(--(a = b), --(c <> "")) = 0 Then cond_average = -1 Else cond_average = Application.SumIf(a, b, c) / Application.Count... 13 Feb 2006 22:44

Run-time error '1004': Method 'Range' of object '_Global' failed
i am developing an excel application to run on a network server which uses several userforms. the userforms collect data in variables and then write them to cells in several worksheets. the application works correctly when run on my local workstation but when i try to run it from the network, i get this error m... 12 Feb 2006 19:07

Assign Macro to Command Button
How do I assign a macro to a command button in Excel 2003. Previously it was just a right-click away, but not any more:( Thankx ... 11 Feb 2006 12:00

Cells.Find woe
I've been trying to get the following code to work in Excel 2003. It's fine if X is found. It breaks on the X assignment statement if Cells.Find fails to find anything. The error is *always*: Object variable or With block variable not set (Error 91) I've tried it with and without using the "set" in front o... 10 Feb 2006 22:30

Help with VB code - average of numbers over specified weeks
I have a spreadsheet that has weeks 1-9 (columns C-K). In each week is 3 numbers (rows 4-6). Those numbers get added together to get a total for that week (row 7). I need help with creating the VB script that when run adds the totals together and gives an average for a specified week range. Example: user clic... 9 Feb 2006 13:10

Sorting issue
Hi There, Underneath sub bugs on: ws.Range("B6").Sort Key1:=Range("B6"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom Any ideas? Best Regards, Sige Sub MakeNAMS() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.R... 10 Feb 2006 10:32

opening csv files
I am opening csv files using: Workbooks.Open Filename:="I:\My Documents\Soccer Predictions\E0.csv" Sheets("E0").Move Before:=Workbooks("csvimport.xls").Sheets(1) Workbooks.Open Filename:="I:\My Documents\Soccer Predictions\E1.csv" Sheets("E1").Move Before:=Workbooks("csvimport.xls").Sheets(1) ... 9 Feb 2006 10:00

Serial Number
Is there a way for Visual Basic to record you computer's serial number? ... 9 Feb 2006 13:10

Calling Oracle Stored Procedure
Well, I am making progress. I have been successful in creating parms for a stored procedure and getting a value returned to me. The problem is I doctored my Oracle Procedure to return a integer rather then the Ref Cursor that I really want to have returned. Does anyone know what Type (DataType.Enum) I should... 9 Feb 2006 20:28

Signature object
Hi It seems that the Signatureset collection / Signature object, although referenced in the help of VBA for Excel, cannot be used with Excel. The example provided by MS cannot be used in Excel. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaof10/html/ofobjSignatureSet.asp Has anyone foun... 8 Feb 2006 14:41