I have few transport timings. Basically, I just want to check their
ONTIME performance in terms of percentages. Is it possible to check
how many % of BEFORETIME and % of AFTERTIME?
My data is like this:

I found the following code which is exactly what I need but am unsure
how to change it to apply to all of Column A?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Set b9 = Range("B9")

I've created a userform which is a calendar. The month displayed is
controlled by a combobox on the userform, so whichever month selected
in the combobox controls the dates displayed in the textboxes below.
I have a problem however. The months available to select in the

I have been reading old posts but couldn't find an answer to my prob.
I have two sheets "sales" and "salesold". They have the same fields.
What I want to do is compare "sales" to "salesold" and copy the
different rows into "compare" sheet.Comparing colums are "n" and "m"

I have a novice question.
I need to create XLS file, which contains some form - this sheet have
a version number (something like 1.1) which increments after Printing
procedure (explain later).

Cells(ActiveCell.Row + 0, 6).FormulaR1C1 = "=VLOOKUP(RC[-4];'Sheet2'!
A:D;3;FALSE)" doesn't work. How do you relatively refer to a cell
within a function? RC[-4] should be replaced.

I have a spreadsheet which I wrote some time ago for checking my
lottery results.  The code is shown below and has worked perfectly on
a number of XPSP2 machines for quite some time.  I have recently
upgraded my home PC to Vista 64 SP1 and installed my copy Office 2003

Hi, i want formula in column F cells that if "A1&B1&C1&D1" values
come
together again in same row in any row of column (A:D) and if they
have

Is there a way to know in beforeSave Event what the you choose in the SaveAs
menu?
I mean whether he chooses Excel workbook, Excel workbook with macro or Binary

I have selected cell A1 to B6 on Sheet1.  How do I then select the same cells
on alls worksheets in the file.
Thank you,
Steven

I want a macro to given formula -
=IF(AND(A2="IncidentLow",B2<=168),"Pass",
IF(AND(A2="IncidentMedium",B2<=24),"Pass",
IF(AND(A2="IncidentHigh",B2<=8),"Pass",

I need to sum a range(columns H1:K6) that meets certain criteria (between to
dates)EX:2007-10-01 thru 2007-10-31.Dates are unknown and not consistant.
My table starts fresh with each fiscal year(october 1). EX:
      A   B        C                D    E    F    G           H       ...

I am having an issue with a requery from my master file when I try to use it
on other PCs at my workplace.
I went into the Edit Query mode and attempted to change the path for my data
file, but I am getting the following message [Microsoft][ODBC Excel Driver]

Anyone knows how to do that?
So anyone can try it for free for 7 days and can get the full activate
version after purchasing the key or it will stop functionning after 7 days.
Thanks.

How do you extract the time from a cell that has the function now() in it.  
For example I have a cell in a worksheet that might be hardcoded with the
time 14:30 and then I want to take the current time of the day and see if it
is greater than 14:30.  The problem I am having is ...