I have a template with formulas but when you try to add rows, it
doesn't automatically add the formulas for that particular column.
How do I automate that to copy the formula when adding rows?
thanks

DST, how do I incorporate that to the sheet?
say... Arizona, they are currently in Pacific time but when California
reverts back to DST, are they ahead or behind Pacific?
how can i formulate that in excel sheet? I think Indiana is the same

I see a lot of important tips here but I think it's being deleted after
10 days...(I read it somewhere).
Is there a way to copy/save the tips I've selected on my own
google/microsoft/public/excel page and look it up when i need it?

From what I understand, Conditional Formatting will only formats
constants in the cells.  Is there a way to format the results of an
expression?
I am having a column calculate a running average, and then graph it on

When I export a file into Excel using Microsoft Office XP, rows are placed
between the data exactly the way they should be. Using Excel in the Office
2003 version, the rows are eliminated.  This causes an issue when using a
macro because the data shifts.  Is there a way to make ...

I want to block user to make changes in multiple cells at a time (at certain
circumstances but disregard it now).
I have this code (in the change event procedure) to undo any changes occurs
with multiple cells:

I have two sheets. In sheet 1 I have two columns. Column A has 500
names and column b has tel numbers but not for all of the names. So
some names donot have any values in column B.
In sheet 2 I have the same two columns. But here column A has only a

I declared a variable:
Dim a As Boolean
Can i be sure that a=FALSE if i don't initialize it as:
a=0

is there a way to have a column round automatically instead of having to
round onto another column?  I don't want to add another column to just
be able to round.

I am trying to develop a form that will dynamically find and list all
available printers including the default printer. From this form I want
to select which printer will be assigned to Application.ActivePrinter.
How do I write a macro to provide the names of all available ...

A simple problem I would appreciate your help with.
I have a work sheet with several cells where time is to be entered in the
format hh:mm. Unfortunately a lot of users are enetering it in the format
hh.mm.

Hi I am currently making a graph off of a pivot,
my pivot changes in size every month and i would like to find a way to
make my graph adjust to the new size of the pivot table,
i also have a column on the side of the pivot table having a

I have a user who has set macro security to medium so that he is prompted
when a workbook contains macros in it. However, now the computer is not
prompting him to allow macros, and the workbook is not opening. This is only
if the user double clicks the file, if he starts excel ...

I'm performing a golf handicapping sheet and within that sheet I'm using an
average of previous scores such as;
In cell AM33 I have =average(q33,w33,ac33,ai33)-35
This value ends up as 11.5...  My rounding goes up to 12 which is what I

I have to jump back into the long forgotten world of VBA... (at least in my
mind).
Does Excel offer a place to store a database key for a given cell?
I need to be able iterate through the ranges of a spreadsheet, grab