I want to create a time array.  For example, cell A1 is the starting time of
6:00 AM, and cell B1 which contains the ending time of 2 PM.  From 6 am to 2
pm is exactly 8 hours.  I want to create an array of 8 elements with the
starting value of 6:00 AM, and the last value in the ...

Is there a way to highlight all of the cells in a worksheet that
change as a result of some action?
I have some worksheets with calculations that depends on other
calculations that depend on other calculations and so on. If I make a

Someone on one of these NGs was asking recently how to prevent co-workers
from seeing worksheets.  I've just discovered (and it wasn't mentioned at
the time) that it is possible in Excel to hide worksheets.  It's not
guaranteed that someone with sufficient knowledge will not come ...

In my "Book1.xls" I have a column A that has 4 rows of the following
text in them -
C:\Documents\Symantec\img1.jpg
C:\Documents\Symantec\img2.jpg

In my "Book1.xls" I have a column A that has 24 rows of the following
text in them -
C:\Documents\Symantec
I want to replace this text with D:\Hold\Folders  in all 24 rows of

I have a Excel Spreadsheet with Records of books. The fields and data
value is entered as the First and Second Column (ColA, ColB). The
records are separated by 2 empty rows. Some fields are missing for
some records: Some record may miss the 'author' whereas some records

In Excel 2003 I'm trying to write a query sentence to get data from a dbf
table where table.date_mov is newer than a value (a cell in the worksheet
which I named as date_min )
How can I get it?

when I put three zero's into a cell,.excel automatically changes it back to
one zero.  I want to keep the three zero's in the cell.  Woiuld appreciate
any advice please
Regards

i want to copy a cell from worksheet 10 to the other worksheets but when i
use copy and i then highlight tabs with shift or control then paste link is
greyed out. how can i copy from one cell in a worksheet to other worksheets
so that when i update the cell all worksheets change ...

I am using an old copy of Quick Books Pro and am dumping into an Excell
spread sheet.  How do I not print old accounts with 0 balances? When I make
them inactive in Quick Books they still show up on all reports.  Thanks

When I select File / Exit, I receive error message "A formula in this
worksheet contains one or more invalid references references" But have
validated that every cell in workbook is empty. Is there something I can
check to see what my problem might be?

I'm trying to understand why conditional formatting formulas adjust
their address references differently then the same formuals in cells. In
short,
Excel is resetting row references to row 1 when a new row is inserted.

how do I fix?

I have a excel spreadsheet that has a formula for each cell.  Is there a way
to copy just the results and past them into a new worksheet?  That way, it
doesn't have to reference and formulas or workbooks?
Thanks,

I'm trying to say something like this =(C$9+30<$D$67)+H$9<>x, which is
probably not close.
I want to make a H9 red when its past due.  It's past due when C9 is
more than 30 days from the current date in D67 and not paid.  It's