QUESTION:
I tried to define global variables in a module with the Public statement.
Unfortunately, their values were eventually lost (possibly because I clicked
Excel's debug reset button or because the application that I inherited uses

I'm trying to rename a list of files held in an excel workbook. Column
A (a named range called "oldplanfile") holds part of the current file
name. Column B holds the corresponding part of the new file name.
Running the code traps the first error but throws up a warning ("Run-

I would greatly appreciate any help in writing the necessary line(s) of code
to determine if a given row (e.g., 8) in the active workbook is completely
blank.
Thanks,

I need to query several records (averaging 2,000) that change every week.
First of all Microsoft query tells me that the SQL statement is too long.
Let's say that I reduce the size of the statement to a workable size if not
other options exist,

I have an Excel file that imports data from a Project file. However,
the users could potentially be on two different versions of Project.
With early binding this created a problem for those who used the
earlier version of Project. Therefore, I removed the reference and

I want to use conditional format in a programmed cell.  I have a workbook
with many pages.  The result page pulls people's initials from the rest of
the workbook.  I need to color in the cell if initials are there.  
Conditional format seems to see the formula as a parameter.

I added a column next to a Pivot Table ("Comments").  When I refresh the
Pivot Table and it imports new data, the format of the Comments column
becomes out-of-sync with that of the refreshed Pivot Table.  No problem: I
copy column D of the Pivot Table and Paste-Special/Formats to ...

When I try to call this method
  wkbk.Close
I get this error message
 Run-Time error '1004'

I have the following line in my macro code:
    KeyCell = ActiveCell.Address
This is used in the line:
     Range("D2").Formula = "=IF('Original Data'!" & KeyCell &

   I am working on a spreadsheet and I need to figure out how to
define a unique string.  In my sheet, column 1 is a list of classes
offered at a school.  So column 1 contains strings.  There are several
offerings of some classes and so the names of those classes show up

I am using office 2007 and I need to have the file path automatically added
to new excel worksheets and word documents. I believe I have to use a macro
for this to work. I have found some macro code for this but none of them are
for Office 2007.

I have an excel file which goes like this in my first 2 columns:
PRODUCT    PUBLICATION
NAME   
Product 1  publication 1

I am writing a macro utility that will be used on several different
PC's.  One step in the macro saves a file using the path of the
currently opened file (where the macro resides).    This step works
for my PC since the macro identifies my specific path.   I need for

recently, i beleived that executing "recorded macro" must produce the very
*same* effect like the action was recorded
but i found the difference for label form control
inserting from control toolbox i created the label, and the recorded macro

Is there anyway to use a workbook name in code without using
application.getsaveasfilename or getopenfilename? As I am trying to create
multiple workbooks from a master workbook and would prefer not to have to
save the workbook every time.