My goal with the code below was to check if the user had entered a vendor
name for each item that had been ordered.  The userform is shown if a vendor
name is missing, and I want them to be able to add it while the userform is
on the screen.  The problem is that the loop runs all ...

Can anyone suggest a macro to assign borders and border colors for a
range in Sheet1 if the value of cell A1=1?  Thanks.  Michael

I can't figure out why the following expression is evaluating to True when
UCase(z(i, 1)) is equal to ""
What am I missing here.  Thanks in advance for any help.
If UCase(z(i, 1)) <> "CS" And UCase(z(i, 1)) <> "" And UCase(.Cells(intPos,

How does on insert a column of times like 4:49 (4 min 49 seconds) When I
select mm:ss it puts it into date format which I don't want. would also like
to be able to sum the column to get a total time in hh:mm:ss

I am looking for the most efficient way (in code) to insert a formula
in the cell next to one that is already populated. I. e. Cells a5-a14
have dates. I want to insert the same formula in cells b5-b14.
the range in col A changes. I have looked at help for autofill,

I am using the "Get External Data" function to download a stock screen from
Yahoo.  The current Get External Data will only download the first 20
results (out of a population of 494).  Is there a parameter I can set to
download all 494 at once?

I have the following code:
vAmount = ActiveCell.Value
Dim EnterAmount As Variant
EnterAmount = InputBox("Enter the amount to Hardcode: ", , vAmount)

I have a list in Excel from A1:A100 with names like the ones mentioned
below:
     Michelle Fooo (michelfoo@exchange.SASMOM.com)
     Myhaass Smith (mysmith@exchange.SASMOM.com)

I want to run some code to hide sheets in a workbook just before it saves...
no problem - I just run this code in the "Thisworkbook" using "before save".
However I then want to open them up again immediately after the workbook as
saved. This is to ensure the user cannot save a ...

I would like to have a Sub that cannot be executed from Excel. The sub
doesn't have a parameters inside. Does the solution is to put a non used
parameters inside?
Thanks!

Excel XP & Win XP
When I record a macro and place an outline border, the recorder of course
lays down a bunch of lines encompassing every facet of the border.
Is there a simple command to produce an outline border?  Thanks for your

My worksheet range B8,D8,E8 through B15,D15,E15 has data like so;
DATE           DESCRIPTION                    TYPE
1/1/2006        Got It!                                 H
1/2/2006        Successful!                         WH

I have a bunch of custom formats that I use that were created by others.
They have many symbols in them hyphens, #, etc, etc.
I also have learned how to have a number displayed with say "total =" in
front of it, but I only know how to do that for simple formats, such as an

I having trouble getting my macro to do what I need it to do.  I have a
sheet where a user inputs data for the day it then goes to a worksheet
for the corresponding day.  For each day there is a budget that I have
a macro that puts it in based on the day of the week.  My problem is ...

I have an Excel worksheet and in $D$1 it has a validation rule (in cell drop
down) that reads allowed values from A1:A3. What I want is when the user
clicks on the drop-down in A1 I want to execute some basic macro. Is their a
dropdown click event where I can capture it so before ...