I have a UserForm that is loaded by an Worksheet_SelectionChange event.  
Since the listboxes in the form are loaded with relative values, I want to
unload the form when either the OK or Cancel button is clicked.
I've tried both "unload me" and "unload frm_spread" in the button ...

Wondering how to do a search for .htm files that are all under one
main folder, but also through a bunch of subfolders under the main
folder.  The code I have so far is:
   myPath = "C:\MySites\"

I have a spreadsheet that someone updated by changing the font colour
from black to red.  Is there a way that I can search cell by font
colour?  Thanks a million!

if the xls file xxx is open and I try the following then Bob's your
Uncle the code runs fine:
Sub runMe()
Application.Run "xxx.xls!xxx"

Hello Group,
I am using
Set fs = Application.FileSearch
With fs

How do I  create a format that will insert the appropriate number of dots
between  the name and the phone number so that I'll have the name
left-aligned and the phone number right-aligned, as in the folllowing
example:

I have made an estimating spreadsheet than has different users on different
computers.  As I write new procedures that I want added to the existing
spreadsheet, is there a procedure that I can build into the spreadsheet that
will automatically load the new procedure and set it up ...

I have a macro that starts by displaying the "open file" window so the
user can select a .csv file to be opened and then processed. It works
great in the US.    I now have a colleague in Argentina that is
running this macro, and when the csv file is opened all the data is

What is the oldest version that microsoft supports.

I have an excel spreadsheet that we keep our contacts in.  Occasionally, we
need to replace one.  When this happens, we just run a macro and it creates
the new contact in Outlook.  Thanks to Gram Mayors template on this.  But,
now we must go to Outlook and delete the old one.  ...

I have generated VBA code to place a worksheet range in a comment. To format
the text for the comment I rely on application.worksheetfunction.len or max
referring to the named range(slow). I am trying to move the data into a array
and do the process differently with the same ...

I am running the below code...is it possible to have reset the two buttons I
added in the Sub Menu_Item macro to the active file name after a "Save As".  
I keep getting an error saying that "The macro 'OriginalFileName!InsertLine'
cannot be found."

I need help getting the syntax right for a loop...
This is what I am trying to accomplish:
Start in A2, run spell check on that cell only.
  Go to the next cell in that row with data (if any, up to the last column)

I'm looking for a macro that marks the current cell in worksheet. It has to
be a dynamic function (for any move the current cell will be mark). I want
that the cell will be colored.
Is there a built-in option for that? If yes how can I defined it?

Hello.  I have a dilemma that is driving me nuts.  I have a spreadsheet that
is to total up the rows associated with a product.  If the product is in 'Kg'
then the total is to be mulitplied by 2204.6.  If the product is in pounds,
multiply by 2000.  The code below is where it all ...