I hided some rows in Excel, and then added one custom views namefor it. But
when I click"Close" the custom views to see the original views that contains
un-hided rows, the rows can not be visible.
What is the problem? What can I do?

my question is:
we have the following table:
     34 29 13 15 7
     15 8 40 11 24

My personal.xls workbook is not automatically opening anymore.  I tried
adding the folder in the general tab of the tools\options box in the "open
files in this folder," but for some reason the "xlstart" folder doesn't save.
It only saves up to C:\Documents and Settings\SFM ...

The coding given by Dave works fine. it traps erros as a whoel in the range.
However...
I have a problem with null values, cells in range can have null values, null
values are OK. I want so search each cell in the range then if its contents

I'm wondering if you can have a drop down list in an InputBox, or if
there is something similar to an InputBox for this function.  I am
running a macro in Excel where I want the user to be able to choose a
city from a drop down list, and then have whatever city they choose

When I have been entering formulas, I have been putting a "=" in the first
space of the cell entry box instead of clicking on the formula button and
entering from there. I don't know why it makes a difference but the IF
functin worked so, I assume, my IRR functions would work if ...

copy it pops up a box titled "Microsoft Excel" that says "The
picture is too large and will be truncated."
For example, right now if I start up Excel it defaults to a blank

i want to move part of an address to another column,
711 W Fairground Rd #3
414 Chestnut St
109 Locust Grove Dr. Apt. 4

I am sure that I must have done something screwy and changed some options
around but I have not been able to figure out what the problem is.  The issue
is that whenever I type a value into a cell it automatically divides that
number by 100 and that is the value that is then ...

I have a tool which uses an excel application object for doing some
calculation and creating a xls file.
Is there a way to exactly protocoll what is done with the excel
application object?

I have created a drop down list box but the list is getting too big and
the user has to scroll down the list to select the data. Is there a
feature I can use to display the data that start with the same string.
For example: If I type "Be" in my box, the box could display the list

I search a lot of groups and only come up with a bunch of them.
I imported a text file that have customers name on it but customers
appear in the the same cell. So I have 5000+ cells on information all
in one column.

I have a range, let's say: (A1:D4), where users can enter a value on any the
cells in this range. However, before any work is done based on the data in
this range, I have to make sure that any the values entered are greater than
zero but less or equal than a certain value. Nulls ...

How would I reference a cell in a master document to other spreadsheets and
workbooks?  I am looking to have a similar date that when is updated in the
master document will also appear on all spreadsheets?  Not sure if linking is
the correct approach?

does anyone know how us a data validation list from another worksheet
within the same workbook?