Can anyone help? I don't understand how to write a simple array formula and I
need to sum up the cost values for all the Part Nbr's that are the same. For
instance Part Nbr 51008 would be $1,344.62. I would like to see this value in
column C repeated for every 51008 Part Nbr. ...

I have an Windows Forms application that uses the Excel application to create
a spreadsheet, saves it and then quits the excel application - all
programmatically.  The problem is that the Excel.exe process remains running
in the background until the windows forms application is ...

I would like to check something out that I'm a little wooly on.  I
have a project, and when finishing, the code sets the collection
objects and their contents to Nothing.  My query is this; if there are
two class collections, A and B, and a number of objects {C} which can

I am trying to produce a count from the following sample data (actual
data over 2000 rows!)..driving me nuts..tried countif but not sure how
to implement it because of dates and multiple criteria
Region  Date

Thanks for looking--
In the VBA below, I attempt to make a new worksheet--"Labels", and then populate
it a column at a time, from an existing worksheet--"Sheet4".
The problem I'm having is that the value returned by

Good Afternoon -
I have a worksheet with 20,000+ rows-
The first column is a unique identifier for a group, and then the rest of
the columns B - M are services. What I need to do is merge the roles so that

I am familiar with using cell offset to move the active cell to a
non-specific cell location in VB; however, I am wondering how difficult it
would be to build a user interface that would prompt the user to input the
number of rows/columns to move up/down left/right. I have used ...

I have a Macro that has a For..Next Loop in it which is (for now) 77 lines
long. Near the top there is a test which requires skipping most of the lines
and looping back to the top. At the moment I am doing this with a label
("NextWS:") parked right above the Next WS command.

How do multiply 2 arrays to generate another array.  Say
Dim one as integer
Dim two as integer
Dim three as integer

I connected some textboxes on my form and using vbCrLf to create a new line
between them. After I insert the whole string into a cell the small sqares
appeared which is not what I want. Could you tell me how to remove them and
remain the format?

Is there a way to add an item to the Start Menu in a similar way as adding a
shortcut to the Desktop?

I have four buttons on my spreadsheet.  (Top of Page, Update, Undo Update,
Redo Update).  I was wondering if there was a way to hide the Undo Update
when the spread sheet is opened until the update button is pressed.  And hide
the Redo Button untill the Undo button is pressed.)

Hello again.
I've finally got the menu structure for my customized ribbon menu.
Now I just need to connect the macros I have to each of the items/buttons.
As mentioned yesterday in my last post, I've read the pdf file from that

I am utilizing macros within some access databases that I have created
through some of the excel macros I also use.  I have a formula that works
ALMOST.  It is supposed to open the database, run the macro, then close the
databse.  I can get it to do everything but recognize my ...

How do I get the following message to:
a) Split onto two lines in the message box (after the comma) and
b)Split it onto two lines within the code for readability?
MsgBox "You have missed out some entries, click OK and complete the list",