I have an apllication where I examine 5500 rows to see if empty and, if so,
"Hide" the row.  Otherwise, "Unhide".  After this macro has been run a few
times, the macro slows to a crawl.
My hypothesis is that Excel's internal "Undo" feature is tracking these

I would like to run a macro in a workbook from the command line. The macro
modifies the contents of the workbook. This is so I can automate a task
rather than open the workbook, run macro, and save.
Thanks!

Is it possible to double click a cell "programatically"?
I would like to double click a ComboBox and have it "double click" the cell
that is set as the ComboBox's ControlSource which will then run a macro
residing in the worksheet.

xl2003, Windows XP:
Sub SaveSelectUnlocked()
Dim SaveAsFilename
ActiveSheet.Unprotect

I am looking to create a reference to a workbook which is already
open.  I have used the code below but this throws the error '32813':
name conflicts with existing module, project or object library'.   The
project that I am trying to reference has a unique name.

(Excel 2003)
Thought this would be simple, but I'm having problems.
I ultimately want to open an xls file, but first have to get the file
name because it changes. So, I need to return the xls file name that

All these years and not used Quick watch...
Just tried it and found those variables added were not retained on Save and
Close.
Have I missed something or do those being watched have to be set up each

WXP, SP2
XL2K2, SP3
What is the maximum number of range names one can have within a file without
running into issues to the point that Excel decides to say that the file has

Is there a special rule in using call procedure macros in a
personal.xls project vs. a VBAproject assigned to a specific
worksheet?  The following macro allows me to search col 3 until the
data runs out & parse out certain characters into col 4.  This works

I am creating format conditions.  Then I am trying to updating them.  But am
getting an error.
So for example I have this:
Dim x As Excel.FormatConditions

I saw
http://www.mcgimpsey.com/excel/lookuppics.html
but where did he keep his pictures?
I just want to show a picture bases on a cell value that is equal to

I have a worksheet where I would like to create a list that contains
all the currencies that Excel has available (similar as when you
select Format - Cells - Number - Currency, and then there is a
dropdown list for Symbol).  Once the person selects the currency the

I am having a problem with calculating time.  I can calculate the difference
in hours over midnight, but what I can't do is not get a value to appear
when I have only put in one number...For instance.   I put in the time I
start, and in my hours it shows midnight minus those ...

I am doing programming based on others' work. Many times, after I inserted
some code, I got runtime error 1004 and there are many reasons explaining it  
such as  can not use a method of a object (e.g. range). THese problem
statements are innocent before. Sometime, I change the ...

I have inherited two spreadsheets that are linked and a VLOOKUP in one is
referring to a range in the other.  The VLOOKUPs all work on the existing
data but as when I add new data, bearing in mind the formatting of the cells
and the order of the lookup range, those do not work.  ...