Hello All -
I'm a VBA beginner, and new to the boards. I've written a program in
VBA (Excel) and everything is going well...except one thing, even after
searching all over the place.

I would like to run a macro, "Perform_Tasks", on a scheduled basis.  I would
like users to be able to select certain criteria for this macro, as such:
             A                       B                  C....
1   Enable/Disable:        Enabled

Columns A & B contain several thousand Project Numbers (e.g., P1052, PA844,
P6721.6, etc.).  Column A has the latest list of Project Numbers.  Column B
has an older list of Project Numbers.  As such, column B is a subset of
column A.  I need to find all of the “new” (i.e., ...

In Excel I would like to be able to restrict the places where a use
can insert rows. I have an idea how the macro should work, but I don'
have enough experience to write the code.
The macro should work as follows:

I have set the Print Area in my WorkSheet to cover the area I need, but the
1st page is in LANDSCAPE and the page following is PORTRAIT.
Is there a way I can have this set to print automatically setting the 1st
page and 2nd pages to the required style?

I want to hide all the rows containing data, below row K, when I click on a
checkbox.  Does anyone know how to do this?
Thanks

How do you make a calendar control display the current date when it is
opened?

When I add a new worksheet, how do I select it? I don't know which
number it is, since I don't know how many sheets there are. Do I have
to count the sheets to find out how many there are, then add the
worksheet and select the next number higher than the count?

I, I recorded a macro to go to a value on another sheet ("Hlist") as
specified on the first sheet ("Snapshot") in cell c4, but it's not working.  
The recording only allows me to look for a set value ("Apples") not a value
located in C4 on sheet "SnapShot"...  Thanks for any ...

There is another group in my organization that is inteviewing consultants
for a VBA position and I was asked to technically interview these candidates
because of my VB experience.  However, I have no VBA experience whatsoever.
Was curious if anyone out these might offer up a ...

I have I macro that write a database into the last row starting in the column
A (see program below).
However, I have a table that has the column A already filled out with
numbers. Therefore, I would like my macro to start writing the last empty row

Hi...
I have 4000 entries in column A similar to...
C:\Common Standards Reports\Spare Parts 0606.xls
C:\Common Standards Reports\Steering wheels 110606.xls

My colleagues at work regularly have a several hundred of Excel
spreadsheets that need Printing on either white paper or as PDFs. I
have created a user form, so that each team member can choose which
print method they want before printing. I have produced some VBA that

I am involved in manipulation files larger than 65000 lines constantly
and is grateful if I can make this script works.
I got this code from the forum which was written by Bernie, when I ran
it in EXcel as a macro, it gave me an error message.

This is something that has intrigued me for some time but I've never really
faced up to it!
When creating a user defined worksheet function how do I generate an error?
For example the following gives me a #VALUE! error where I want one (FTE