I recently upgraded my personal computers at home to MS Office 2007.  I am
getting ready to write some macros in excel for a project at work and they
use pre-2007 MS Office.
Can I use 2007 and save the work as 97-2003 format in order for it to be

I found this example on Ron de Bruin's site on how to create a custom
Ribbon...
http://www.rondebruin.nl/ribbon.htm
I followed it to the letter but the Ribbon does not appear at all when

Sorry I have to post a new thread. I have not been able to do it the way I've
been told.
I dont know VBA or programming.  I make macro by recording steps.
I have this macro which ends with a loop as below.  It works, but I need it

Does anyone know if there is a setting in Excel 2003 where we set number of
rows a formula should pick up?  I have a sumif formula to calculate range
from row 2 to 20,000.  However, it only calculates the first 1000.  Then, I
have to change the range to 1001 to 2000 for the next ...

How do I count the number of cells only if E1:E100 contains "ray" and F1:F100
contains a "d"? I only want the "d's" in column if column E has Raytheon.
Right now it's counting all the "d's" in column f and all the "ray's" in
column e, but I only want column f to count if column e ...

I need help with a loop.  After looping through the procedure,  when the
active cell is empty I want to exit the loop.  Would you please give me the
codes to do that.
Thanks

I'm trying to create a summary worksheet involving figures from other
worksheets, but SUMIF is giving me problems.  I'd heard that SUM works over
multiple worksheets, but does SUMIF?

Not sure this is possible but...I have a cell that has a number range in it
and based on an amount in another cell want to calculate a new range.  For
example:
Initial Range: A1 = 10 - 12

A regularly used workbook will no longer print all the pages I select as one
document. It breaks it up into two or three segments and I need it all
together. Currently my workaround is printing and scanning to save as a PDF.

For some reason I'm not able to round to the third decimal place.  This is
the formula I have in cell H61:  =ROUND(AP10,3)&""""&" x "&ROUND(AR8,3)&""""
Where, for example:
AP10 = 6.600 (formatted to 3 decimal places, with no " marks)

I would like to be able to click on a cell then click on a clock to enter my
start and end times, i.e.
start time:    click in a cell, then on clock icon or button:  9:00 AM,
end time:      click in a cell, then on clock icon or button:  10:00 AM

i'm working on a shipping log that i do now by hand and would like to
automate if possible. every load equals 1,000 and alot of the loads are split
loads.
     a              b              c              d                e

I posted this in "Charts", and want to expand it to "General Questions" -
I've only received one response.  I am trying to create a plot that uses
x-axis values of time, using "Microsoft Office Excel 2007".  Most data points
are in one-hour increments, but a few are only minutes ...

Hi there, I thought I posted a thread about this, but can't seem to find it.
Anyway, the problem is I have the macro below. It works when I run it
manually from the macro menu, but bugs when I use VB to edit it into running
automaticaly (tried Wookbook_Open and ...

I have a WorkBook with 200+ Worksheets.  I sort these A-Z with a VBA code.
Somewhere I read a tip on how to GoTo a Worksheet directly without scrolling
the Tabs.  Am I dreaming?
Bob M.