This question is just to satisfy my curiousity, as I don't (yet) believe it
has a significant impact on my code.
I came across something and I can't seem to find the answer.  Everything
I've found mentions 'how' to use the collection, and not 'why' to use it.

Okay so I have a label with the ID = lblResult.  I want to display
each factorial of 1 through five.  But when I run my program it only
displays the value of 5!.  Can someone help me put the values of 1! -
4!?  I would like it to display as follows:

Can any one help whats wrong with it.
Code:
Sub FindMin()
 'variables to hold sheet name, starting and ending comparison rows

My problem is this... I want the user to click on a row number (any
row) - just so the entire row is selected. Then I want to position the
code at column A of that selected row, then select each cell along the
entire row.

I'm trying to copy a long formula from Cell "F3" down to "F500" but I
only want some of the references to change. Here's my formula in
standard and R1C1 notation (sorry about the word wrapping):
{=IF(B3>1,SUMPRODUCT(--($C$3=TWC!B4:B999),--($E$3=TWC!A4:A999),--(TWC!

Hi - I'm tring to open an Access 2003 database from Excel 2003 and append a
range of Excel cell values into an existing table.  
When I try to declare the connection variable, I got a compiler error for
"user-defined type not define" for

Using 2003.  I have conditional formatting set on a column of cells
"Current Status".  I need to format the color of an adjacent cell
("Trend") based on conditional color of "Current Status" (I cannot use
conditional formatting - reason too long to describe).

I have the following working:
With aWS.Cells(r.Row, r.Column)
     .Value = oWS.Cells(r.Row, r.Column).Value
     .Locked = oWS.Cells(r.Row, r.Column).Locked

If I write a line of code like Activesheet.rectangles.add 50, 50, 50, 50
What is the system of measurement Excel is using to Draw the rectangle at
Location 50,50 and 50 wide by 50 high?
Inquiring minds want to know...

Some bright souls suggested that my many-user spreadsheet might
benefit from late bound references rather than early bound, in order
to be compatible with the myriad versions of Excel being used by my
colleagues.  I am beginning to see their point, but I'm still rather

Hi, I have tryed this code listed below and it work, but as you see it only
list files in folder spesifyed in: .LookIn = ...
what I want to do is to find files from a dialogbox.
Any of you who can tell me how?????

What kind of code could I use to import a table from access to a
worksheet in excel?
I'm thinking of opening the database, opening the table, select all,
copy, and then pasting into my excel file.

I know I can do an array calculation in one cell (for example A1) and
reference A1 in a normal formula.  However, is it possible to have the
array formula inside the normal formula?   I hope that made sense.
TIA

Hello, I have the current macro assigned to clear the contents of
unlocked cells.  What I would like to do is also include the clearing
of 2 Option Buttons as well.
Thanks for your assistance!

I have a checkbox on a user form that when checked adds $30.00 to the
value in a textbox. What I want to do is add more code that takes the
$30.00 away or subtracts it.  Say for example the user hits the
checkbox and realizes that this was an error, then unchecks the