I have a spreadsheet where I am trying to do two things:
First: I want to create a forumula in column "Z" that looks at the
number in column "Y" and if it's a negative, then multiply the number
in column "X" by 1.1.  If the number in column "Y" is a positive

I was wondering how you change and Excel footer format.  Like when I put
something in the center section of the footer it spreads what I wrote evenly
across the bottom of the page and then when I go to put something in one of
the other sections on the left or right, the ...

I try to find the menu, but are confused about the new layout...
Please help...
Thanks
Bjorn

This is just an example of what I want to do but if I have a worksheet
with, say, 10 rows and 3 columns and I want to write out certain rows
to a new spreadsheet, how can I do that in VBA for Excel?  Here are
the specifics:

need formula to change a gps settings in spreadsheet from UTM to
longtitude and latitude....    Any ideas?

I want to format a column of cells so that when 012208 is entered with the
numeric keypad, 01/22/2008 appears in the cell. So far, I'm getting
6/3/1933.
Thanks,

For a sheet with invoices I need to totalize column values from a
different currency (cell format Accounting). How to perform? All cells
can have any currency USD or EUR.
Column A   Column B:

Hello
I posted this message to beginners but I wondered whether it would be
better here:
I have a workbook with 95 sheets containing information for different

I need to get the lastRow dynamically because it can change.  This is
not working but I don't know how to revise it.  I want the last row in
column C.
lngLastRow = ws.Cells.Find(What:="*", After:=ws.Range("C1"), _

Hello
I have a workbook with 95 sheets containing information for different
customers and I would like to extract information from 3 cells in each
sheet to a 96th sheet to use this for a mailmerge document.

How can I copy and paste from one spreadsheet to another without the
destination referencing the source?  For example, I have 2 workbooks
with identical worksheets, but containing different data.  One has
graphs  in one sheet that references to data in other sheets ... how

I am a novice at VBA and have struck a little problem. I have made a table
in Excel that compares various Insurance Companies covers. I have checkboxes
for the user to select which companies he/she wishes to compare and then a
Compare button which takes the user to the worksheet ...

I have developed a macro on a PC with Excel 2003 version that works
fine.  I also tested the same macro on another colleague's PC also
running Excel 2003 and there are no issues.  I sent the macro to a
colleague that is running Excel 2007, and when he runs the macro it

But it doesn't.
At least, Excel 2002 doesn't.
(For those involved in the numerous posts on this issue, what I mean
by "change the default" is change it permanently, so that it survives

i have an excel 2002 spreadsheet that is not protected, but the
auditing tools are unusable [faded out]. why?
Tonso