Below, I entered what goes into A2, A3, and A4, respectively.  They
get entered as text.  Notice that only the first line of this is
what's different.
A2

I have developed an application using Visual Basic & Access. My query is i
am getting the report from access database to excel while exporting data from
access to excel i want all the cell with NO to be filled with red color this
can be done by conditional formatting but i want ...

I have a user form with a combobox that has a row source set to cells
formatted as dd-mmm-yy. My problem is that the combobox displays this as a
serial number and then writes the date to the worksheet as mm-dd-yy. The
regional settings are set to English.I guess this is basic, ...

I have a workbook with many sheets.  I want to look for specific data and
then do some action.  I can get the macro to work until it cannot find what I
am looking for.  How do I tell it that if it doesn't find what it was looking
for then to go to a different sub routine?  Ie:  I ...

I have Excel 2003. I want to change the fill color of a cell in relation to
it's own contents (ex. I will set a number as a goal for myself. There will
be a cell that will calculate my progress. While I am still under my goal
number, the fill color of the cell will be red and the ...

Is it possible to read and write an Excel file from Visual C++ ?
Thanks,
Claude

I don't know if this is possible and if it is how I go about it but here
goes....
I have some data on a worksheet called Data
I have some summary info on another sheet called Summary

I want to apply an AutoFilter to a Structured Table within my
worksheet. Row 1 is a header row, and row 2 contains a series of
inputs needed for calculations within the table. I only want to apply
the AutoFilter to row 3 and down (which contain dates), but my code

I am attempting to get data from a workbook called MCL.xls.  I am in a
workbook called wb2.xls.  MCL.xls is my customer data. I made a sample
of MCL.xls with the name wb1.xls which contains a sheet called
CustList (the same as in MCL.xls).  I then copied and pasted the first

Whats wrong with this?  I get a #VALUE error:
Function DotProd(Vector1)
DotProd = Rows(Vector1)
End Function

I get a runtime error 1004, application or object definition on the line with
the asterisks.  While debugging this I noticed that it runs through the 5th
iteration of "I" then it stops.  This macro does the page setup on each page
of long spreadsheets.   There is also a routine ...

I accidentally marked the other thread answered and it is getting urgent.
I apologize for any unnecessary confusing.
 In the code I pasted in the thread I had some code that was commented out
but I accidentally uncommented and it WAS CONFUSING.  Sorry.  I tested the

How can I do a StrComp of multiple text strings?
Example: StrComp(Target.Offset(0, -5).Text, "AMX", vbTextCompare) = 0
or  StrComp(Target.Offset(0, -5).Text, "AMX, BAVR, BAVS", vbTextCompare) = 0
                                            or is it

It is possible to have two Worksheet changes macros for two different
cells names Input_SO and Input_SRT on the worksheet named
'Input' (Cells located in the same worksheet) even though they have
different names?

I have a lot of Excel files with macro inside. Is it possible to set the
level of Macro Security to "Low" once and for all (Excel 2002 SP3) ?
Thanks in advance.
Regards,