Hello, I have a project where I am trying to take a data set  (in this case
the GA Cash 3 lottery results) and use an Excel formula to count the number
of times a 3 digit number occurs in the dat ( example 318).  Can anyone tell
me how to set this up?  Or can anyone tell me what ...

I'm using Excel 2003.  I have a workbook with two worksheets, both of which
have Data Validation cells.  On one worksheet, the font size of the
validation drop-down list is larger than on the other.  The drop-down lists
are using identical values.

I have the following code that does the following:
*Sorts data according to one column B
*While the SOB values are all equal in Column B, it goes through data and
identifies the bottom and top position of each row and stores it in a Long

I want to load a validation drop down box from array values. If I
define this as a string I am limited to 256 characters.  If I
reference the first element in the array the drop down box contains
that one name but i want to list them all.  I have provided the code

Hello and thank you for your time...Here is my scenario. I have created an
audit  in one worksheet of Excel 2002.
The audit in worksheet A contains a drop down list to display each of the
ratings (i.e. meets expectations, needs improvement, etc) and another drop

Hi,
How do I ensure that my named ranges supply data to my data validation
drop-down lists that are in the proper aphanumerical order? These lists are
dynamically changing based on re-populating data which is then used to

I have a printer function to cycle through  network numbers 1-9 because the
networks are assigned dynamically.  I'm trying to debug it since it stops on
the i = 1 and doesn't loop. I know the current network number is 2.
Public Function getPrinter(ByRef nError As Long)

Option2ListBox populates with the items contained in Col H of the 'Schedules'
tab; the user can then select 1 or more of these items.  For each selected
item, I want Excel to go to the 'Schedules' tab and delete any row that has
that item in Col H.  Problem is that the code is ...

I I have a macro that enters data into cells and want the data values to be
read back to me as I enter it.  The SpeakonEnter doesn't work for this
because I'm not actually pressing 'Enter' - it's the macro putting the data
in.  Is there a way to make this happen by using the ...

I am trying to use an array in VBA but I am not having much luck. This is
what I am looking at:
I am looking for a match between the Customer and the Date in a list of
Customers and dates. So say the Date and Customer are specified, now you want

I have locked a VBAProject, I know the password however as soon as I
try to unlock it it goes nowhere just hangs.  I have 2 other projects
that unlock just fine in the same workbook.  Luckly I just finished
saving the code to notepad so it wont be too difficult to recreate.

I searching for a method as well as a specific way to get information from a
table of data.  Here is a small subset of the data:
#    ID Tag    Mach    F    Cause    Fail Type    Site ID    Site Name    Sort Plan    Run
Start Date Time    Event Date Time    Delta Hours    Event Day

Using Office 2003 and Windows XP;
I have a sheet containing some 50 rows of merged cells: "G12:H12";
"G13:H13", etc. note: G to H
I want to shade them using something like:

Here is my issue....I need to keep track of how many hours a certain
instructor will teach during the year.
This is based on the instructors last name (smith) and a field setup
for the course hours (i.e. 2).  The problem i run into is the fact

Some one tried to help me with this, but did not worked, so sorry for
reposting
My Original Message
I would like to see today's date in