Windows XP Pro SP2
Excel 2002 SP3
Seems that cells that are conditionally formatted don't return an expected
Interior.ColorIndex value.

In one tab of a spreadsheet, I have two columns.  Column A contains my
VLOOKUP formula.  Column B contains Inventory item numbers.  This tab is
called "Sales".
The other tab of my spreadsheet is called "Items".  This tab, also, contains

The Microsoft documentation states that the delete method for a
worksheet object issues a boolean False if a user clicks Cancel on the
dialog box that gets generated warning that data may be lost if the
worksheet is deleted.  How can the return value from this dialog box

I have a large worksheet that I need a modified "IF" formula for.  The
standard one won't work, and I think a macro is the way to go.  ANy
suggestions for a macro code to accomplish the following:
If A1 contains a text value, leave that text value there and skip to A2

Hey, I'm kinda new to vba and was wonderying if anyone could help with
my code.  I want this template I created automatically sent through
email and have it titled (subject) as a cell in the worksheet.  I
found some code to send email but it was a little different than what

i have a shortcut to a  file with marcos ( so excel file sharing is
not a viable option since it doesnt work with macros) that has been
distributed to two users (actually more but two works for the example)
neither of them ever need to save the file.

I use the code below to select a column of data and replace . with a /
so I can sort the data in chronological order (as a date).  However,
this only works if I manually find and replace (with the find and
replace dialogue).  If I use the macro below, the dates are sometimes

I have a problem with duplicate shortcut keys, and I was wondering if anyone
knew any way around this.  I have developed some personal macros that I use
control + a, d, or r to activate and these macros are stored on the
Personal.xls spreadsheet because I use them all the time.  ...

I have a macro with the following formula
OnProdOrd = (Cells(x, 10) - Cells(x, 11) / Cells(x, 9))
I'll use x = 1 for the example
Cells(1,10) = 10

I'm guessing, from the posts I've seen, that the following code will
open and read the contents of a CSV file:
Sub read_file()
Dim strTemp As String

I have a VBA loop that reads file names from a directory. In the end I have a
worksheet with a bunch of filename listed (plus other file info). I also add
a button on each line that allows me to open the file. It all works
fine...until the user plays around with the sorting.. ...

I'm writing a macro that enters a formula or text values into a group of
cells (if I've stated that wrong, sorry).
I have 2 different elements that I want to enter.
1st is an IF equation-- =if(d9=k9,"ok",d9-k9)

I like to use the codenames of the worksheets in my code, because they
do not change
even if the user decides to rename a workshet name.
When I use the codename directly in my code all methods and properties

I got an example of this code from another discussion.
If Sh.Type = -4167 Then
   Application.EnableEvents = False
               Sh.Range("B1:C1").Value = Date & "  " & Time

I'm a bit stuck with the above, I can use the Modify method to change
the data validation criteria for a given range as in the code below:
   With Selection.Validation
       .Modify Type:=xlValidateList, AlertStyle:=xlValidAlertStop,