I have two cells that carry two different times as follow
cell A1 has 00:05:00
cell A2 has 00:04:00
cell A3 should display the difference in negative way(-00:01:00). I only get

when I try to run the following code (on an existing diagram):
With ActiveChart
    Dim globalLstFile as String
    globalLstFile = "02 KOBA_XYZ_C3-06214  02- 20.7-20.8°C Touchprobe

I  had this before, but it didn't work weel! I may have not made it clear.
Range C5:C29 containes either letter C or letter M.
Range D5:D29 containes either letter M or letter F
line 5    C    F

Hi to all,
I have worksheet nammed HCP2006. colomn EK has numbers in some of it's
cells. The code below is to select only the rows that has numbers (not
blank) in colomn EK starting from row 6.

I have a cell (E9) that has calculated the hours worked 'D9-C9(D9>C9)'
and an adjacent cell (F9) to convert this to decimal ('E9*24').  If
there is no entry in C9 and D9, F9 reads '-24'.  How do I correct this
to show 0.00?

here is what i want to do:
2 columns: A & B
col A: list of months (12): cell A1:jan/06, A2: feb/06, A3: mar/06, A4:
apr/06, A5:...... A12: dec/06

Example as to a formula I need
Add               Subtract           Balance
Column C     Column I          Column J
$1000          -$500              =$500

I have 3 columns of data. (approx 1,000 rows)
The 1st column has an identifier number (ie; PN22001-A in cell A1)
The 2nd Colum has a colour (ie; Mist Green in cell B1)
The 3rd colum has a stock number (ie; 4505-3456 in cell C1)

How do I copy a formula to an entire column without getting the same
response?  I want Column K to equal Column E times Column I plus Column E but
only if there is data in the other columns.  I want to copy the formula down
but when I click on the column header it just types my ...

I have a spreadsheet formua that I'd like to add a test to, for name in
another column.
The formula is =SUMIF($F$3:$F$218,">="&A3,$G$3:$G$218)
-SUMIF($F$3:$F$218,">"&B2,$G$3:$G$218)

I have the need to generate an EXCEL dataset, not macro driven, which
has formatting that just can’t be done in the CSV type of file format.  
Generally my requirements are for a 6 column table with bold column
headings and a title line above the column heading that is also bold ...

I am programatically trying  to add a checkbox.
but it looks like you have to give pixal locations
   ActiveSheet.OLEObjects.Add(ClassType:="Forms.CheckBox.1", Link:=False, _
       DisplayAsIcon:=False, Left:=111.75, Top:=197.25, Width:=85.5, Height

Have set up an Icon on Toolbar with a standard Macro which I like to use.
But each time I open a new Excel get a message if have multiple instances of excel open..
FILE IN USE.
PERSONAL.XLS IS LOCKED FOR EDITING

I have 3 columns.
C -I=J
These columns are continuous and I keep adding amounts to cells in column C
and deducting amounts from I column and need to end up with a total in

I have a problem in using an If Statement and adding statement
together.
A        B     C     D
Carl     1      2     3