i would like to place a simple yes no msg box, have tried the code i
thought worked, but not having much success,
simply want a yes no button with message,
Yes msg box closes, no file saves and closes.

I have been working on this macro for about three days. I can't seem to
figure out how to do this (primarily the part where it checks column A,
described below), and I have searched endlessly, but nothing fits what
Im looking for. I cannot download any add-ins, since my work network

=SUMIF(A6:A2000,"(left(a6:a2000,4))=(left($K$14,4))",F6:F2000)
I want to create a sub total of all values in column F, at certain
subtotal cells in column F where the the first 4 (or other to be
set)characters of a code in cells a6 to a2000 match the first 4

I'll try to explain :
One xls file has a few tabs for my different investment accounts
(stock/funds/CD's etc)
On the Total Portfolio page there are references to the other tabs so as

Having used Beta 2 of Office 2007 I was not expecting any problems when I
installed the RTM version however I'm unable to open a number of
spreadsheets, the follwoing error is displayed:-
The Worksheet was created in an earlier beta version of Excel 2007, and it

Everyone gets to see formules like this one sooner or later:
A2: =IF(AND(A1=0;B3=1);IF(C17=C18;2;3);IF(OR(D12=1;D12=D13);4;5))
When jou put a remark to a cell, the remark will show when crossing
the cell with your mouse.

Hi - i bet this is simple - but how do i convert NOW() ... or TODAY()
into a julian date  like  31206 (day 312, year 06)
thanks

I have set up a macro to do a series of calculations automatically in
spreadsheets with various numbers of records. The macro uses the 'fill down'
command to apply the formulae to all records. What is the simplest way to
stop the fill down at the last record? I set up my macro using ...

Hi, I'm creating a macro and wanted to know if there's a way (and what
the syntax would be) to have the macro look to see if a particular
worksheet exists and if it does delete it and if it doesn't exisit to
continue moving on in the macro.  Thanks for your help.

My query is less about the technical side of Excel & more about which
technique to use.
I have a database which tracks the monthly depreciation in car values,
for cars of various ages (i.e. 1,2,3 years old etc.).

I have the following code below in which I want it to check the value
of two cells and if the two cells = certain values then hide rows on a
different sheet.
For example if A12 = "BLUE" AND B16 = "DOG" then hide rows on sheet

Suddenly unable to color cell border.
Software: XL97 SR-2(l) on WinXP-pro w/ SR-2 with latest Microsoft
Windows updates.
Hardware DELL Dimension E510 3 GHz with 1 Mbyte RAM

Is it possible to have a main workbook with information from other  
workbooks at each worksheet? I have 20
workbooks with information. I would like to haven a main workbook with on  
sheet1 every row from the

I live in South Africa, and I have an interesting problem that persists in
Excel 2003 and 2007.
=TEXT(NOW(),"dd mmm yyyy") returns 15 Dec 2006
=month(now()) returns 12

How do I do the following in Excel 2003?
I have a column of six digit numbers (About 24,000 Rows)
Example:
154563