I'm trying to open an xls file on a computer that has 2000 Excel on it. I
get a 'file error:data may have been lost' or something similar to that. It
opens fine on my laptop in compatibility mode (I'm running 2007).
Thanks for any suggestions,

I tried to amortize my mortgage and was unable to get it to work right.
I used this formula that I found in Excel's  help screens:
PMT(rate,nper,pv,fv,type)
and I entered these values in it:

Is there a way to sort with merged cells (2 rows each with column A) with
unmerged cells (Column B).  I have the following:
c    3
    1

OS: MS XP
Excel: 2002
I have a macro which I use to update the page Settings in an Excel file.
What I don’t know how to do is:

As part of a larger program, I ask users to enter a name for the
worksheet.  I want to have in built in error checking to make sure
that if the user enters a blank, just numbers, special characters, or
anything else that would cause a name in naming a worksheet that it

My macro first sorts Column A which contains a string of text
alphabetically. It then compares the text down each consecutive row and
prints, "Repeated Entry" in Column B next to it if they are found. It then
sorts Column A:B alphabetically along Column B. At this point and to do ...

I am trying to come up with a formula to display a percentage in
another cell from a long string of other random text and if none to
show up at 0%.  For example, the string in C1 is "(10%, 1, 15hr) blah
blah blah"  i need a cell that finds the 10 and displays 10% and if

I would like to figure out how many people have taken up a discount of 33% or
50%, at what rate (earlybird or regular) and what they bought.
The columns I have are item (1 item, 2 item, 3 item), rate (EB or REG) and
discount (0%, 33%, 50%).

I have a user who reported this, and we have verified the behavior on
different computers.  She has a spreadsheet with 10,000 rows and about 50
columns.  When she highlights the whole spreadsheet, and selects Format
cells, wrap text ,the cpu levels rise to 100% in Excel 2007 and ...

Good day,
Please help with the following.
If I do a Top 3 list and it shows up as follows
 A                    B

I want to click on a cell in an Excel spreadsheet and then press a
control button that will perform an operation on that selected cell.
E.g. if my cursor is highlighting cell A4, I can press a button that
will do something with the data in A4. Is this a Worksheet_Change

how can I write a Macro to set the Activecell in the activesheet on the last
blank cell in column A?
thanks in advance.
peiman

I am looking for a formula to define the number of tiles I need (full
equivalent) to put in a room with an L-shape.
I have tiles size 45 by 45 or 60 by 60 cm.
I can calculate the net size of the floor of the room, but also would like

what is the pupose of having the following two lines at the beginning
Application.ScreenUpdating = False
  Application.Calculation = xlCalculationManual
and the following two lines at the end of the Codes for VB?

When I double-click a file on desktop, Excel says it can't find it. It opens
fine if the program is running. I've tried to save it under different names,
and that doesn't matter. Can you help?