I have a user form which I want to use to sort data on a worksheet (having
defined a name for the data rnage). There are 2 frames on the user form. The
first frame has 3 options buttons which I want the user to decide from the 3
columns which to use as the sort (using the ...

How do I format a cell in Excell to give me the quarternumber from a date?
Example: 2006-09-20  give quarternumber 3

Excel 2003
I have the following two lines in a simple macro.  The macro should put the
date for last Monday in the selected cell.
   SubDays = (Weekday(Date) - vbMonday)

I am selecting data for various compounds and would like to then take
that data and average it and then put it into a cell.  The problem I am
having is that I don't quite know how to average this data.  My code is
below and probably outlines it better.  Basically I can have multiple

I've done something stupid.
I've created and filled in about 30 questionnaire sheets, each on a seperate
identical worksheet. The questions run down the sheets. The easiest way I
can think of to analyse the results is to compile them on one page, one row

Hello, I have the following VBA macro that allows a user to enter
times via the keypad (without having to enter the colon between hours
and minutes or seconds).  The macro transforms a 3 to 6 digit number
into a time entry.  It works great for the columns that I actually

I have a subroutine that uses a formula to determine if a cell is the same
as the one below it, and the formula, =EXACT(a1,a2) is evaluating properly in
some cases, and in others, it's returning #VALUE on the last row of data...
where it compares a cell with data, vs. a blank ...

If I am referring to a range not on the active sheet, why does this work
triggered from a Macro button on Sheet1...
Sheets("Sheet2").Range("A2:G57").ClearContents
But this will not?

I have rows of data as below, I want to group by col 3 & col 4 then sub total
by col 5, how can I do this via macro VBA?
1     2          3            4         5
A    3000    PETER     GBP      -510.00

I have an excel sheet that contains 2 columns (that are relevant to
this topic)
Column H:H contains a date formatted: 9/14/2006  2:04:27 PM
Column Q:Q contains a job number formatted: 20060914143253. (As you can

Hi! I have a long list in a spreadsheet. In my macro I want to loop through
that list and do series of operations as long as I have not reached the end
of my list. I am having some trouble with my code. The thing is that it
depends on which computer I am running the code on. On ...

I'm trying to run this function but I'm getting an error witht the
Intersect function for my second worksheet. Any idea why?!
Function SelectRangeToChange(X As Range, ToFind1 As String, ToFind2 As
String, TabNum As Variant) As Range

I want to perform a calculation on a range of dates as follows
Date 1 - 2-7-07
Date 2 - 8-7-07
Date 3 - 2-7-08

Hi, in ranges f8:f15 i have
3.98
1463
3.98

I know this is simple but finding it seems to elude me. There must be an
Excel function that will return the count of cells in a column that contain
any value. they will be filled from the top down with no blanks.