How do I copy one cell and then selectively paste that cell to many other
cells by simply single clicking?
I know how to do it by copying, holding down the control key and
then double-clicking on cells. Then clicking on paste.

I have a workbook with multiple worksheets representing dates of
classes.  On each worksheet it has all the class information including
participant names (B7:B20) the class date (B2) and various information
about each participant (C7:G20).

i have tryed to get help with this problem before
and it worked one time and something happened and I lost the progra
again something changed
please this is a very important problem that i have would it be out o

In Excel 2002 how do I set printer defaults?
For example I want it to print Landscape and Print Grid Lines everytime?
I know how to set it for an individual document
Thanks,

Is it possible in Excel 97 to protect a spreadsheet in such a way tha
data can be entered in unlocked cells but formatting changes cannot b
made?  I have a spreadsheet model set up that works great except i
users copy data from one unlocked cell to another the formatting of th

I am unable to use the MOD Function  within a module. The line gets
highlighted in red and does not offer any comments or hint as to why.
However if I use the function within the spreadsheet I get the desired
results.

Say I have the following dynamic named ranges (12 per year, but here are
three):
TERR_2004
CAT_2004

I have a question regarding using several workbooks to handle a job.
I am tracking clients (in this case inmates in a jail).  I have a set
of core data that I call the "Master List".  It contains the
following:

I know very little about VBA, Alas
I have a VBA app which contains some call backs which repospond to msgs from
a server.
The call backs basically receive data and notifications and display them on

My previous posting went out with "Microsoft "as the sender, this is an
error on my part as I had not completely set up my news account. My
apologies to MS
_____________________________________________________________________

Can anyone please offer any advice? ..... I am using data validation on a
worksheet and would like to resize the message box that appears when the
cell is selected. Can this be done in Excel either using an option or by
using some VBA?

I sent an Excel-2k spreadsheet to a friend and when she opens it up
a column of cells with calculated values has #name? in it.  The cells
contain vlookup functions.  I looked in the help for possible solutions
but none of them solved this.  I remember fixing this once a while ago

The below code is for drawing random numbers between 1-35 (not repeating).
The drawn number is being displayed in A1 and at the same time beeing added
on column B1:B35 as the macro is executed repetedly via a control button. So
far so good. But I need to add a new dimension to this ...

Is it possible to calculate dates in Excel within the footers?  
I know how to get what I want (a week from today's date: =Today()+7) i
the spreadsheet but want to do the same thing in the footer.  
My apologies if this is pretty basic and any suggestions would b

I need to find some way to delete certain rows in excel automatically
The data that i have contains some gibberish every now and then whic
doesn't occur in a repeating pattern.
However, it is always marked by" <square> Persh "(when i say square,