From what I can tell from the help, there is no way to rename a cell
and have all of the references updated.
If I need to rename a cell, I have to delete the old name, add the new
name, then manually reapply the new name wherever I need it.

I have a table with monthly and annual payments for several years.
I named the cells in the monthly payment column MP1, MP2, MP3, etc.
This works fine.
When I tried to name the cell for the first annual payment to AP1,

Always something new, I guess.
This hasn't happened before; something changed, apparently.
Have a single page with columns going from A thru F.
Fairly narrow columns.

Dear Sir/Madam,
I have a problem relating to the aforesaid file (SKU011.CAB). A few searches
for solutions on Google has lead me to deduce that problems of this kind are
extremely commonplace and difficult to resolve in the circumstances but I

از شما می خواهم راجع به امکانات فارسی برنامه های میکروسافت را به من معرفی کنید

Hi math guys/gals,
I have an "oscillator", points go up and down, (amplitud or frquency
not constants) and need to identify if the newest point is probably a
maximun or a minimun of such a function.

I have an Excel worksheet and in $D$1 it has a validation rule (in cell drop
down) that reads allowed values from A1:A3. What I want is when the user
clicks on the drop-down in A1 I want to execute some basic macro. Is their a
dropdown click event where I can capture it so before ...

Is it possible to lock some cells so that they do not refresh?
I am using Randbetween to generate a starting order for a race.
and use other formulas to advance the winners to the next bracket.
I need to lock out the starting order so that it does not refresh as the

Dear Friends, Need your help in the following :
Here is my requirement:
I have a worksheet which has columns 1,3,6,8. Which has few rows with a
unique values in column 1.

How do I put the present date on a cell such as A1 so that any day I open
the file, the correct date is shown.
Thanks in advance.

Question: Recently, when attempting to format cells, whether it's for
color fill or lines, boldface for type,and a variety of other cell
formats--I now get a warning box which says 'too many different cell
formats' even when I work with a duplicate of the spread sheet from

I'm thinking of purchasing a visual basic book to use as a reference.
I use VB often and have a pretty good basic understanding but would
like to get something to use as a reference for more complicated issues
I come accross.  Any suggestions on a good book?

Good Morning!  I've run into trouble again with an IF situation <g>.  I have
two columns, one shows amount owing to an account and the other shows amount
paid to that account, in other words, a debit and a credit column.  In
making the balance column, I don't know how to show the ...

I have a worksheet with about seven ranges (class periods in a school
day).
At the top of the worksheet is a list of students' names and other
info.

I just wanted to wish all of you good folks a safe and happy holiday season
where ever you are. I get a tremendous amount of help from this group and
it's appreciated. I'm leaving for California tomorrow for my vacation /
holiday get away. I hope that all of you do something ...