I am trying to sum a range, column "C" on the condition that the value
in column "B" >= 3000 and <4000. The formula I am using is
=SUMPRODUCT((A1:A9>3000)8(A1:A9<4000 ),(C1:C9)). When some playing
around I either get the sum of the entire column or 0. Neither answer

I have created a user form that will put information into a
spreadsheet into the next available row.  I am now trying to create a
function in that same userform that allows me to search a criteria and
to update that same userform with the information allready entered

i am using this to populate an array
   arr = .Range("B12:B" & lRow).Value
then i use this to work with the array
   For x = LBound(arr) To UBound(arr)

Hello, I've searched high and low and can't find the exact code I'm
looking for... and unfortunately, I'm unable to figure how to string
together bits of code to achieve the desired result.
What I'd like to be able to do is have VBA copy and paste a specific

I've got a macro that parses through a Word document and copies and pastes
tables and figures into an Excel workbook.  We've got a weird intermittent
bug where the wrong picture is pasted into Excel.  (We're using Office 2000.)
It's pasting the same image twice in a row, even ...

I would like to make a little button that, wehn pressed, would delete
all files in a directory except for the ones that I specidy.  It would
be nice if I could display a listbox and check the ones that I wanted
to delete but for now, I can just hardcode the files to keep.  I can

I have a macro that contains the line:
.Cells(irow + 2, 5).FormulaR1C1 = "=R[-1]C*R[-2]C3"
The first time a worksheet is created and the above code is executed
when irow=15, the formula produced in E17 is "=A65536*$C65535".    If

Below is a simple function which I have registred with Excel using a
"BBB" signature specification, ie accept 2 doubles, return double.
extern double __stdcall divide(double a, double b)
{

I have a good query however one of the output columns I want to convert from
text to a number. I think that the CLng is the correct option I just do not
understand how to get the output to be a changed by the CLng function.

Following is my code.
     Range("F88").Select
   Selection.FormatConditions.Delete
   Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=E88<1"

I have a workbook that is read only so can't be saved. When the users does
'save as' how can I add a letter to the beginning of whatever filename he
chooses. It will be the same letter each time.
M

I have a macro that uses the following code snippet that worked fine in 2003
and XP.
 Set Wsh = Worksheets("Summary Sheet")
 Wsh.Activate    'Needs to be activate for PrintPreview

I am making.. or trying to make a macro to clear data from fields on my
sheet. I keep on getting different error messages and nothing I have found so
far ( going on 60.00 worth of books) have help me find that anwser.. I am
going to take a class... i am in more urgent needs of ...

Can you get the tooltips on command buttons in excel? I have a number of
buttons scattered around a page and dont want them on a toolbar so is this
possible?

I had an old worksheet that I needed to unprotect, but forgot the password.  
Through this forum, I found some code that was unable to unlock the sheet.  
After running the code, a message box said, "one possible password is
"-----".