Realtive newbie here!
I am looking for a macro that will move worksheets to a master
workbook.
I have an order form with macros that save a file as a certain name and

I know that if you allocate a pointer ( handle ) to a worksheet, range, query
table, etc. and don't release it then when you call quit from the application
the Excel process isn't released.  I have no problem until I call Refresh on
a Query Table.  I programmatically using C++ ...

Hi, this macro is supposed to copy all the rows with a specific value (in
C25) to another sheet. But, only the first row will be copied. Can someone
help?? Or have a better suggestion??
Sub Copy()

Can someone please help me with a code that puts
the row source of the list box to the activecell
listbox1.rowsource =

Below is a macro that will take a list of data from sheet1 and firs
create a new spreadsheet for each item located in col C.  it will the
take the data on sheet1 and place all the lines of data associated wit
the new spreadsheet.  it’s a very nice program but I need to alter it

Sorry for cross post, initial post was probably wrong group...
Cell D3 = value
Cell D4 = value > D3
Range C3:C20 and B3:B20 have values in them

I am looking to average a range of numbers, but I want to exclude any cell that has a zero from the Average.  In this particular case, the zero's are filler only and have no real meaning but they are distorting my figure.
I can't seem to find the magic formula to make it function.

I need to calculate how many times that a new item have been put in excel
based on the last months entries.
Anyone got a way to do that ?
(It needs to be a running proces, so that we at all times can see the last

Have stumbled on the fact that I can use "end sub" (with message box) if that
process is not to continue.
I have other message boxes that are to exit the complete procedure, which
consists of  12+ "call" routines.

How would I add this formula as a worksheet function with VBA
I can't see INT, MOD or Year in VBA. Also want to change C2 to change
to activecell column + row 2.
=INT(((C2-1461)-SUM(MOD(DATE(YEAR(C2-MOD(C2,7)+3),1,2)-1461,{1E+99,7})*{1,-1})+5)/7)

Lokking for (macro) solution to copy content of Text box to Cell
Example :
From time to time content of Text box is manually changed.
Every time when macro start content of this Text box is copied in cell A1

Need some help.
I have a column in Excel which looks something like this:
BUSY15321130|-0.9
FREE15321130|-38546.4

The following procedure does not trigger when I open the workbook.
I tried both as read only and NOT read only. It works great when I step
thru it (F8).  It would seem to me to be a problem in the This Workbook
Module, but I don't really know what to look for.

Hi i'm trying to improve an error handler that i'm putting together. I
have a case statement based on an error number. If the error is due to
a string value being null i would like to list all strings in a message
box or something and show all the values?

Can anyone advise how I can get a Macro to start when eg "David" is selected
from the drop down cell?
When eg David is selected from the list, I am wanting the Macro to run which
would insert text in another cell eg "January is the Store manager"