I have created a macro which automatically compares the data in two
Worksheets, Worksheet A and Worksheet B.  It does this by using the first
column as a reference (this column contains a unique identifier). The macro
identifies: (1) new data by copying it into a worksheet named ...

I need to show a message box if the user enters an "N" in any particular
cell. I currently have code in the SelectionChange procedure, which checks to
see if the cell direcly above or to the left of the active cell has the "N".
This causes a problem because if a user is entering ...

Can someone give me the correct code to create an outlook task from excel?
Thanks
Albert

I have a file with 10 diffrent tabs.  Depending on the option button chosen
on the first tab, certain columns need to be hiddein or revealed on a second
tab.  I'm getting an 'application-defined or object-defined error' when it
tries to select a range on the newly activated ...

i got 4 checkboxes linked to cells on sheet1
and a commandbutton1.
when userclick that button i need the print range on sheet on to be mailed
with the defauld mail client to webmaster2@gmail.com

How do I set the default number format to be #,##0;[Red](#,##0), which will
avoid the dash sign for nrgative numbers and add a thousand seperator. I am
still using Excel 2000. Thanks for your help.

I need to the syntax for running a Vlookup on a fixed array, but each time
the size of the array is changing. is there any command for this or can i use
a variable that will stand for range each time?

I'm trying to add a custom header based on worksheet cell values, so I've
created the variable 'NewHeader'.  When I run the code, the header font is
HUGE even though I've indicated 12 pt.  What have I done wrong?
Sub AddNewInvoiceHeader(NewHeader, InvoiceName, ShName)

I have a macro, "GetQuotes", that downloads some market data. I need to run
the Get Quotes macro every 10 minutes from 6PM Sun to 5PM Fri.  RBS gave the
following reply:
Simplest is to use the Windows task scheduler.

I have a macro (GetQuotes) to download market quotes. Now I need to write a
macro to run the GetQuotes macro every 10 minutes from 6PM Sun to 5PM Fri.
Don't know how to do that.
[RBS posted the following reply:

I need a macro which will look at each row and if the cell in column Z =2
then the cell in column C should be formatted Yellow, if it = 3 the cell will
be formatted Red and if it is greater than  3 the cell will be formatted
Grey. There are 941 rows startimng at row 7. I know ...

How do I retrive data from my spreadsheet when I type in seperate cells a row
heading(A-column) and a column heading(row8)?  I'm trying to retrieve the
data to be used in another calculation.  When I type the text in a blank
cell, I cannot get it to recognize that it matches the ...

I have an excel work book with a number of vba macros.
I have placed in "ThisWorkbook" a workbook_open() and workbook_close()
sub procedures.  The workbook_close seems to always fire correctly.
The workbook_open() either does not fire , or fires sometimes.

I have a macro which clears last years information and makes the worksheet
available for a new year. I want the Macro to increase last year's balance
date by one year. How do you get the Macro to increase the date value of the
active cell by one year?

I am trying to create a task from a commandbutton in a userform.
This is what I got so far:
Sub CreateTask()
Dim oApp As Object