I set up a drop-down list for my spreadsheet with the options "Fax, Mail,
Pick-up, Interoffice". When I pick fax, the next block in that column only
gives me the options, "Mail, Pick-up, Interoffice". If I pick one of those
three, the next block has two options. I want to be able ...

How would I Dim the name of the current sheet, obviously Sheet1 is not
my sheet name
  ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R4C1:R14C1"
Thanks in advance

I am using "application.volatile" in a function procedure in order for the
procedure to be called.  The function does not refer to a cell value and
therefore won't be called unless .volatile is used.
Basically, what I am trying to do is to set the worksheet background to a

Is it somehow possible to check if a row's been inserted? Is there any
construct of code or do I need to loop through a field and check that
'manually'?
thanks for help

I think I have a problem with an xlt file.
I've written this xlt with some macros in it, and it works fine.
I need to protect the vba project code with a password, but if I do
that, then when I quit excel a dialog pops up asking for that password;

I use the code below to open workbooks and fill and array.  Unfortunately the
workbook names change.  I have 50 workbooks that I extract data from.  Can
someone please assist me in adjusting the code so that is opens the books
regardless of the names and then fills the array ...

H, I'm attempting a program to enter data into a list box and I'm having a
few problems, this is my first attempt t a VBA list box. Thank you for any
help you can offer Thanks Jill

I have a textbox on my userform and neeeeed it formatted. When the user
enters it I want them to enter a 10 digit number only but also have it
display a '-' in the middle of the number.
for example,

I have some sections in the sheet where I have named cells to be used for a
Vlookup. I was wondering if there is a way within my VBA code to use vlookup
and access those sections to get the data I want?

I'm having a problem usin the Applcation Ontime line in Excel VBA.
I'm probably using it ok but I am missing something.
The purpose is to run a procedure each day at say 7AM even if excel i
not open and even if the computer is not on.

I need to save timesheets as their week ending date, can i do this
automaticaly with a macro and control???
TIA

Is there syntax that will allow me to move a sheet of choice to the end
without requiring the number of sheets being known?
Arturo

I have a workbook with multiple worksheets.  My "MAIN" sheet has Names
in column A, and Sales data in Columns B and C.
The other worksheets are titled after column A.  I want to cycle through
the names on my MAIN sheet and copy the data to the worksheet matching

Hello, I am relatively new to Excel macros. Does anyone know of a way
to make a macro that will search each cell in one entire column and
replace just part of a formula? For instance, I have an entire column
that has formulas such as =C10*1.05  and I want to replace the 1.05

I am searching for and replacing for different variables of code in the VBE.  
I already know that I have pick the reference on the Microsoft Visual Basic
for Applications Extensibility 5.3, but how would I code this?  Any help
would be greatly appreciated!!  Thanks!