I'm wondering about using "Set Class1Var = New Class1".
This routine needs one occurance of that statement, but it doesn't
seem to hurt to execute it millions of times.  (I know I could've said
Dim Class1Var as New Class1).

I've got two multi-select listboxes on a userform.  The idea is that
listbox A contains all possible items and listbox B is a subset of A
defined by the user.  I'm struggling with capturing the selected
values in A so that they can be copied to B.  Here is my code:

I have two files each holds a long list of names and other personal
information.
The names are located in Column A. How can I compare the list of names and
ask Excel to print out on Column B of File2 the word "match"  if an exact

I need to get the file names and modified date for file using 'PDA*.PDF' and
searching all subdirectories
What I have tried
Dir() will only give me the file name

there is a visual basic macro I need to updated in a workbook.  There are
well over 100 workbooks that need this update.  There are also many changes
to the worksheets in the workbooks.  I have written several procedures that
update the worksheet data in an separate workbook that ...

I need to know how to do this for rows instead of columns.
I have the same issue but with rows instead.
Public Sub MyHide()
 Dim rngCell As Range

From this msg:
******************************************************************************************
2007-09-13 10:21:10
(http://groups.google.ca/group/microsoft.public.excel ...

I have a cell in D2945 (changes daily). In that cell it reads "Grand Total".
I would like to be able to go to that cell, then go to the begining of that
row, selece row A-W, bold, change color to blue and font 12 points. Does
anyone know how to do this?

I'm trying to run a procedure in access using excel VBA.  I set the
access object library reference and ran this code but it hangs on the
appAcc.run command; Run-time error '440': Method 'Run' of object
'_Application' failed.

Is there a way to have the workbook count sheets and then have a message pop
up when it reaches a certain number?

How do you remove a cell (Range) from a range object.  
I have a named range and I want to remove the selected cell from the range.
IE.  
Range namedRange; // Contains selecedRange

How would you most efficiently convert this table:
Date1  Ticker1  T1Price1
Date2  Ticker1  T1Price2
Date3  Ticker1  T1Price3

cell AC21 = 4.5 (hard coded number).
Cell AF21 = formula
Anyone have a macro that will goalseek cell af21 so it = cell ac21?
thanks a lot

I have two possible collections that I might want a particular sub to operate
on.  Both are Dim'd at the top of the module:
Dim my_AEs, my_AMs As Collection
...

I am trying to find any cell with the word stop in it and turn that
cell red. Later in the code I have all red cells delete. However, it
doesn't always work. Sometimes it does other times it doesn't.
Typically after I try running the program more than twice it stops