Worksheet "Orders" (19,000 rows, give or take)
In column A: Customers (of which there are 41 unique entries)
In column B: Locations (from 1 to 8 per customer)
Other columns have additional data from each order.

I would like to automatically turn a row color to yellow if the current date
is greater than a "needed by" date column. What is the best way to do this?

I can't get the grid lines in my worksheet even when I check it on the
options. What am I doing wrong?

I need a macro line that will delete the contents of cells in a range
that have formulas that return a blank cell. the if formulas in the
cells return "" or some number. i need to empty the cells that do not
return a number.

Are there any VBA resources for for doing scientific and mathy things?
I'm looking for a compendium that has a variety of math macros for
special functions, FFT/Lomb/wavelet, image processing, optimization,
etc.

I keep getting those little error flags in my spreadsheet even though it
works ok and then I have to `ignore error` which takes ages to sort, is thre
a way to stop the `error message` appearing.
thanks

Hi, hope someone can advise.
I have a spreadsheet that I use for my running club 'Grand Prix'
competition.  Members run in 10 events during the season and they score
on there highest 6 places.

I have a column containing text like *http://somedomain.com* but its
not hyperlinked. How can I select the column and convert to hyperlinks
? I know for each cell, on editing if I hit the ENTER key, it gets
hyperlinked. But how do I do that for an entire column ?

Hello experts,
I'm attempting to convert excel data to an access database.  I cannot
find the access add-in link that is available in previous versions of
excel, nor does it appear available from Microsoft's web site.  Any

To uninstall an add-in, i'm using a .vbs script. My problem is when Excel is
open and i try to "uninstall" the addin, i get an Access Denied error.
objXL.AddIns("LMI!Comptable").Installed = False
I think there's two ways to resolve my problem:

Greetings All,
    I need help with a really slow spreadsheet.  It consist of a database
of 6 columns and 1400 rows that feeds about 6 other sheets that contain
5500 instances of the SumProduct function.  Each instance of the

I know that excel can open file of other application , like dbase .dbf
files. However, once after opening these files, they are no long be
usable in the original application. Will some one please tell me how
and is it possible to have these files be used again in the original

i have enter the record in the row, and inside the cell, i'm using
ALT+Enter to make more line for the record, but i would like to know
how to sum of the value in this cell??
e.g.

This is a simplified example of what I'm trying to do.
Assume A1 to F100 has data.  I want an array formula that
will calc something like
=SUM(IF((A1:A100>0)*(B1:B100<0),A1:A100-xxxx(C1:E100),B1:B100-xxxx(C1:F100)))

Sometimes, when i type text in a cell, , the AutoComplete feature not
automatically fill the remaining characters, sometimes does.
Any idea what to do?
Th.