I work as a personal trainer with older adults.  I want to keep track
of their progress now kept manually. I want to track their progress
and chart the progress.  Seeing their progress is a huge motivator for
them. I was thinking of using Excel but I seem to be "caught in an

I have a question regarding the below code. This works great except for one
problem, once I have this code, it ruins
another macro I have set up. The other macro is designed to copy a set of
rows and paste them in. Essentially adding a job to our Manpower tracking.  

I am trying to set the color of a range of cells based on the number
of a looping variable  (Count).     The following code gives me an
error indicating that the color can't be set using a variable name.
What would be an alternate way to do this?

Can I assign a password to pop up when there is a particular cell selected,
say B6 in order to gain access to that cell for modification?  Alll other
cells should be able to be modified, just not that one without a password.

I am creating a new Excel-based program (see www.PKTutor.com for a
preliminary demo). Given the plethora of Excel vesrions out there, I
am interested to know which version is regarded as best for modern
development of commercial products. Backward compatibility seems

I have an Excel worksheet with controls (buttons, combo boxes). The controls
work on one workstation, but do not work on another workstation (e.g., when I
click a button, the button does not even depress). The security settting on
both PCs is medium.

I need some suggestions/directions/ideas on how to solve my problem.
Description of my problem:
I have some data ranging from column A to HH & ocuppying 25 rows,
which i

I'm attempting to 'merge' three reports into one .... basically, three
of the same exact report, just with slightly different base data.  At
this point, I've transferred the 'raw data' from each of the reports
into one (each with it's own tab) and I've got the structure of the

I have a macro that will open a read-only file - is there a code so that the
pop-up "this file is a read-only file, etc." doesn't pop up?
Thank you

i,
I have a pivot table created using 'external data' from an Access data
source using a dsn. Now, when I use the '!' form the pivot tbale toolbar, it
hangs. perhaps because of too many rows > 50000. Can anybody help on how to

I got error message "Select method of Range class failed"  
from  target.offset(0, -1).Select in change event when I try to assign the
target.
Clara

I've figured out how to do it in a Word document, but the object model or
something must be different for Excel  (2003).
How can I have a msgbox pop up and tell me how many comments are in a
workbook?

JLatham graceously provided this code for me to use to sum values in my
'Daily Reading Master Log' sheet, based on a month selected on the 'Executive
Summary' sheet.  The summed value is then assigned to a specif cell on the
'Executive Summary' sheet.

I have an Excel sheet that has a script attached to a button that will email
the form via outlook once the button is pressed. Anyway, is there any way to
make certain fields required before the email is sent and produce an error
message if those fields are left blank? Cells D13 ...

** Using Excel 2003 **
There was a help page that said go to VB editor, make a new module, and a
function - then call that function within the workbook.  So I made a new
module and typed: