i need to know how to calculate of the subtotal for below:
 A       B          C           D                E      F
Year   Quater   Week  Department  Agent  Action
2005  1              1         Sales       Fanny   No

Can some one give me a hint as to how I can write a sub to display
elapsed time meter on the sheet, say in one of the cells? This should
tick evey second while my other macros are running. I want to time
running of my macros but  I want to see this timer ticking every second

I want to delete a sheet from workbook without any instructions o
message box. When i try to delete the sheet it ask
"Data may exist in the sheet(s) seletion for deletion. To permanentel
delete the data, press delete."

hi all excel gurus....
can some one pls advise me if it possible to identify numbers in pairs
that sum up to become 0?
i have data like

Can someone please show me the proper syntax for using "and" and "or"
operators with "if" in a Macro?  Can they be used together?

nYear = CLng(Right(TextBox3.Text, 4))
Could anyone tell me why the above code works in some excel versions yet in
others it does not.
xl 97 at work keels over yet mine does not.

is there anyone that can help me with a little problem.
I would like to hear, if there is anyone of you that can tell me if it is
possible to get excel to make frames in a cell depending of the contens.
ex.

For some reason my normal, standard Msgbox doesn't popup and the center of
the screen anymore.
I can't think of any reason why this suddenly is different.
This is a completely standard Msgbox, so for example this will do it in a

Last week, I began having problems with viewing PDF files and website
animations in Internet Explorer.  Something new that I noticed was that there
are four password-protected VBA projects (pdfmaker.xla, funcres.xla,
html.xla, and atpvbaen.xla) in my Excel VB editor.

I am trying to ensure that a user can only use my spreadsheet if they enable
macros.  I have used the workbook close event to set all the useful sheets to
veryhidden and have a warning sheet visible advising that they must enable
macros.

I created a custom menu 'Extra's'. This menu is created with an Add In. But
now I want to add new menu items to this menu. These menu items are created
by another Add-In. But I can't mak it work.
for example:

Below I have a macro which will wait for Internet Explorer to load a
web page by looping.  Is there similar code for producing the same
results using Netscape Navigator?. If it makes a difference, I'm using
Netscape 4.7.

I  have a small spreadsheet downloadable from:
http://www.greenwichyachtclub.co.uk/racing/Book1.xls
I am trying to find a way to calculate the value in column A
This value has to be the average of the first 5 values in the same row

I have in my "Summary" page a table which has four coloumns and an undefined
number of rows. There's nothing under this table, so the firs white line
means the end of it. I need a macro to export this table as a kind of backup,
in a txt o cvs file.

I am working on a macro in Microsoft Excel 2000 vba.
I want to concatenate the two cells to the left of it.
This is what I have so far:
   ActiveCell.FormulaR1C1 = "=CONCATENATE(RC[-2],RC[-1])"