I would like information on using the LIKE operator to do pattern matching.  
VBA Help does not recognize LIKE.
Is there a better source of information or tutorial examples?
Thanks in advance for any help or pointers

I have an array defined as:
Dim team_vs_team_array(15, 15, 5)
Through code I populate each value within the array reading from
various worksheets, and completing calculations along the way (each

I have a couple of questions regarding the worksheet_change function. I have
a process modelling software that prints out results at certain times to an
Excel worksheet. When a new value is received by excel I am using a
worksheet_change macro to perform some other calculations. ...

I should know why this doesn't work...but
get 'Wrong number of arguments or invalid property assignment'
and can't resolve it.
With Worksheets("Stats").Range(p$)

Greetings all,
I've come across somthing truly bizarre - an intermittant case of a
value mutating during assignment!!!
For i = 3 To 1103

Excel XP & Win XP
I took a macro to loop through all the files in a folder from Debra's site:
http://www.contextures.com/xlfaqMac.html#LoopBooks
I tested it without any changes and it worked fine.

I had one rather large sub that worked great, I broke down into 8 seperate
subs to simplify code changes later on.I have a user form with a run button.
Originally it ran the one sub and worked great.Now with it split into many
how do I go from one sub straight into the next one ...

I have an EXCEL 2003 worksheet with four columns and about one thousand rows
containg this sample data:
NAME          BIRTHDATE          ANNIVERSARY          DEATH DATE
John Smith   June 1, 1920        July 15, 1940            August 1, 1980

I wish all the forum members a great New Year...
Could anyone tell me what are sendKeys used for and what are they?
Also it wud be great if someone answers the following...
where to find a list of the sendkeys parameters.

I have 30 or so rows of data each with about 23 numbers in them.  Each cell
in that range has conditional formating in it to see if it is over a target
number.  I now need excel to count how man of them are above goal.  I am
using colorindex 5 and have some code that will count ...

How can I modify the code below to change the font color to red?
   With ActiveCell
       .Cells.Value = "9999"
       .Offset(0, 0).EntireRow.Columns("D").Select

Inspection Date    Hot/ Cold            Condition Code   Comments
9/29/1989                 H                              0     Comment
1
11/10/1989           H                           0     Comment 2

DSUM - Modifying the function...
I am not sure if everyone knows the DSUM function but I am trying to modify
this so the criteria and the field names are in two separate ranges.
The Syntax of the DSUM is

I'm trying to transpose selected rows of data from a worksheet to columns on
multiple worksheets, however the transposed columnar data will be on
non-adjacent rows.  I loop through the rows, columns, and worksheets.  Part
of the code within the loops is:

Hi ladies and gents
I have a question:
How can i lookup a value in a range then select the cell that value
Thanks for the help