Okay here's my problem,
I have a VBA subroutine (Marco) that I want to run, BUT in my worksheets I
also have functions that I've written (in VBA) that are Application.Volatile.
So when I run the subroutine, Excel also has to re-calculate "all" the

I have five sheets and they are named by weeks (ex: 5-7-2006 to
5-13-2006, 5-14-2006 to 5-20-2006, etc.).  In another sheet, Weekly
table, I need to put these sheet names in the first row.  Basically,
whatever name you give to the five sheets, it should automatically

Hi I have been using a script that removes subtotals from worksheets, then
updates data, then adds in subotal again. It had been working. I then updated
the macro script as I required extra columns in for the subtotalling. now I
receive the message "Entire subtotal row will be ...

I know you can pause a macro for a certain number of milliseconds using
Public Declare Sub Sleep Lib "kernel32" _
   (ByVal dwMilliseconds As Long)
Option Private Module

I need to switch between 2 open files in a macro.  I know the name of one
file but not the other.  What code can I use to activate the workbook that I
don't know the name of?

I have the following code that works in a loop
Cells(j, 2) = Sheets("Sheet1").Cells(j, 5)
What I am struggling to do is get this to work when "Sheet1" is in another
workbook (that will be open). Is there code that would read something like:

I need to check the cells in a column to see if any of the cells contain
certain data. For example:
Apple Pie
Apple and Berry Cobbler

What code can I use to count the number of non-blank cells in a selected range?

I want to refresh a query based on a variable. I have the following
which does not work.
Sub AddDetailSheet()
Dim Proj As Variant

I want to refer to multiple ranges, but I do not want to refer directly to
the cell address since these change all the time. Instead I want to refer to
the cells by using an expression like variable.Address or something like
that. Normally when refering to multiple ranges you ...

I need some help editing code for my macro. I want to bold all line
that have the word Total in them. There are 2 problems I'm runnin
into:
1) I read the macro script - all cell addresses are hard codes . Ho

I'm unable to find it.
Where did they hide it?
How can I assign a key to macro?
Bruno

I have the following formula in cell A5 and throughout the sheet
=if(Sum(A1:A4)>0,Sum(A1:A4),"") If the answer returns "" (blank) I want my
macro to hide the row using
"Range("MyRange").Columns(5).SpecialCells(xlBlanks).EntireRow.Hidden = True".

I have recorded a macro (through Excel, not VBA) that I would like to
duplicate/share with another user.  We are using Excel 2003 - any way to do
this besides re-creating the macro on the other machine?
Thanks.....

I need some help saving files during a macro:
1)  I want to specify a path & file name for the active file to be saved
with - no user intervention required. The following code works for the file
name but location seems random - how do I specify where the file should be