Hello, I have a user with a Spreadsheet with a list of names. When Autofilter
is used some of the names are missing on the list. When the list is sorted in
asscending order the name then appears on the list. Does anyone know whether
this is a known bug in Excel or has anyone come ...

Thanks Kevin for the update.
But my problem is bit different, let me explain:
1. I take the data from an extenal DB to excel on daily basis
2. The volume of data changes every day (may be more or less than the

I have the following macro:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Application.Intersect(Target, Range("U246")) Is Nothing Then
If Target.Value = IsError(xlErrDiv0) Then

Is it possible to increase the maximum number of rows beyond ~65536?

I am defeated.  Don't know what happened.  Every number I key in become
'divide by 100' ie 5 becomes 0.05, 300 becomes 3, 6000 becomes 60.....
Plse help.
Email Signature Powered by NameCardOnline.com -- Exchange | View | vCard

How can I merge cells in the same column that contain the same data.   ie.  
if the first 5 rows have one value, then the next 6 rows have another value
and so on.  The total number of the cells that need to be merged varies.
I need to find an automated way of doing this as I have ...

Running Excel 2000 on WINNT.
Recently had a Document Management System installed only to find it
interfered with running macros. The application was rolled back and a
registry fix was provided to refresh the Office applications but did

I have createad a database and alphabetically sorted the items - is there a
shortcut or a quick way to jump to a particular letter rather than scrolling
down the whole thing to find 'r' etc?

I would like to have a button, which when clicked refreshes the source data
in the excel chart object. I want to write a MACRO.
The data which is used for the chart/graph keeps changing hence want to
automate the same.

Hi  this is the formula that I am using for a lookup.
=IF(ISNA(VLOOKUP(H7,'2006 Discount
'!$E$2:$Q$374,7,FALSE)),"",VLOOKUP(H7,'2006 Discount '!$E$2:$Q$374,7,FALSE))
and this works fine, however, if the answer is not found here I want it to

i am making a questionnaire and i am trying to do it so when the question is
answered then if it is wrong it goes red or if it is right then it goes blue
or green. i cannot find the formula for this can someone please let me know
what it is.

Excel 2003 - Ihave mulitple cells with different values in them and want to
insert a pound sign infrontof each value.  I can do this one by one but is
there a quick way to insert a pound sign in multiple cells without a) doing
each cell one at a time and b) without deleting the ...

Is there any limit for the max number of characters displayed in the cell in
Excell?

Full Handicap      Playing Handicap
   4.3                      4
   4.4                      4
   4.5                      5

using todays date what formula do i use to calculate a person age using their
date of birth