I'm trying to create a summary sheet from 3 tabs of data.  Want to add the
first two values and subtract the third.  It's working, but sometimes my
first value is a negative value and when i subtract the 3rd positive value my
result is wrong.  I.e., first value is -300, second ...

Please some help here...
Is there any function in vba that identifies an integer number?
I got a program that divides a static variable in a list of many others.
I want to take an action with those numbers that are exact multipliers.

In Excel Pro 2003, I am trying to enter data from one cell only (A1 – Jones)
and have it saved in another column of cells.(Column C1). If I enter ‘=$A$1’
in cell C1, I get the name in that cell – which is fine.
My problem is that I now want to enter a new name from cell (A1 – this ...

Hi,
Im seeking some kind of help here
Ive got a range of dates given by DATE function (01-16-2007    01-17-2007  
01-18-2007, etc.), i've also formated the cells so to get only the name of

When I use VBA in Excel 2003 to copy ActiveSheet.Rows(1).Value to another
worksheet such as Worksheets(2).Rows.(1).Value, why the hyperlink function in
ActiveSheet.Rows(1).Value does not work in the other worksheet? How do you
make the hyperlink stay active in another worksheet?

If I have a sentence in a cell, what code can I use to search a word in that
cell?
Eg: A1: "I am happy"
I want to test if A1 has the word "happy" in it.

I have an Excel problem.  I am opening a spreadsheet and the text in the
cells is not appearing but I can click on a cell and see the text in the
Formula bar...just can't see the text in the cell itself....but, when I turn
off wrap text it all appears like it should but shouldn't ...

I have installed Excel 2007 as part of an Office 2007 installation. At the
top of each worksheet it always says 'Non-commercial use'.
This is really annoying & uneccessary. How do I get rid of this ?

Am using Excel 2003.
I am using a workbook with various worksheets named differently.
For example, I have the following worksheets in the "tabs" area:
Sheet Kiwi

I work on a monthly newsletter and need to take an excel file and copy it
into my Indesign file.  
How can I do this correctly?

Is there any way to show all entries in a column, even though there may be
different items in a 2nd column? I would like to have Part#s show up for all
columns. In below table 163822 is blank in 2nd row and I would like it to be
there.

I know that you can increment values in a column by entering a few values,
selecting them and then dragging the lower-right edge down the column.  But
what if you want to do this for thousands of rows?
Is there some shortcut or function that you can use to get say rows 1 to

an old boss of mine is in the real estate financing business and used
to use a couple of VB programs that he had someone write to basically take
as input some numbers from a customer, apply them to some tax formulas and
produce some nice printed reports illustrating the different ...

I accidentally made a infinite loop with a for statement. It basically
msgboxes for every cell in the sheet. I can't get out of it with Esc or End.
How would I stop the macro?

I have one spreadsheet comprised of 20 individuals that are identified by a 5
digit number in column A and 10 columns of associated data related to these
individuals. I have another spreadsheet comprised of 1000 individuals
identified by a 5 digit number in column A and 20 ...