i am doing a spread sheet to display averages for statistics but i wan
to be able to put 2 dates in 2 cells and be able to select data for
those dates and/or the ones between them
eg

I am trying to get round the problems using sumproduct in VBA and have
made quite a few changes using tips I have found, this includes
changing to Application.Evaluate("....
Can anyone see where I am going wrong

Can anyone help with the following? I'm trying to save an excel file to a
private ftp site and the following code is failing to save.
ActiveWorkbook.SaveAs Filename:= _
       "ftp://userid:password@ftp.txdot.gov/SiteManager/TESTTx103a.xls"

I would like the code below to not go in debug mode if the variable a is not
found. What is the code I should insert? Thank you!
Public Sub Macro1()
Dim nRow As Integer, i As Integer, a As String

I have the following code in my workbook.  It allow the user to utilize the
outline and grouping, but it will not allow them to add and delete rows.  
Private Sub Workbook_Open()
With Worksheets("vendorcommodities_detail")

Everytime I think I'm getting pretty smart about XL, I see something
new I've never seen before. I'm working on a spreadsheet that was
given to us by a consultant. It has a neat feature I haven't seen
before that I'll try to describe.

I want to write a macro to import the data from a Web page.  I know that I
can type in the whole URL in the Edit Web Query in Excel.  However, problem
arises in this specific web page.  In order to get the data, I have to use
the mouse to click a specific word on the web page but ...

Hi. I have a payroll workbook.  Each row has a Cost Center and a Fiscal Year.
The Fiscal Year for each Cost Center changes based on the calendar month.  I
have been hard coding the changes in the Fiscal Years but my boss wants a
solution that doesn't require hard coding.  He ...

I need a VBS script for an Excel Macro to print a worksheet but only if one
of the fields on the sheet has been filled. At the moment my Macro prints
every worksheet that might be needed and I'm wasting a ton of paper and ink
every time.

I have taught myself some basic VBA with a few books I have and searching
forums like this. I have an application that is perfect for getting data from
the user via a list box, but I have not been able to find a decent, fairly
simple example of how to do this. Can anyone ...

I am trying to create an array formula through VBA code. I want the formula(
for a particular parameter) to appear like this in Excel  
{=SUM(IF(Q9:Q11<>"Rejected",I9:I11,0))}
The code is this

I get assignments with the name in various formats.
First & Spouse LName
LName, First AND Spouse
Lname, First

I am trying to export spreadsheet data from excel to access and executed from
within excel;
below is a VBA script working with access 2003 but not with '07
I am assuming the problem is with DAO Object Library

Hi! I want to name a range in VBA. I know in what cell I want it to start,
lets say A1. I also have a variable that controls both the height and length
of the range (they are of equal size). This variable is called x.
I have:

I have lost my Add in Password, now i require it very badly.
Can someone recover it to me...?
Ragards
Thyag