In excel 2002 (SP-2), when I do a Delete<Sheet, it does not give a
confirmation.  How can I turn on the the delete confirmation ON??
Thanks
Madan

Can you produce a database from an Excel spreadsheet but using the first
column as fields and the top row as records?
Many thanks,
David

I have created a simple macro with Tools.Macros.Record New Marco. Ho
can I create a button and asing my new macro to it. I wan't to have th
button in the worksheet, NOT a menubar button!
Thanks U al

Sorry, i don't know the name of this function;When entering text in a column
excel keeps the data (in a list?) and next time you type the first letters
of a previously entered string it fills the rest for you.This is a great
time-saving feature.

Can some kind person explain why this code
produces Run time Error 1004
LastRow = .Cells(.Rows.count, "A").End(x1Up).row

I'm sorry about the cross-post, I don't know which group is best for this
question.
I have encountered a problem with an Excel/VBA application I'm developing.
One of the things I do is creating sheets on the fly using VBA, like this:

I use Excel very little.
I have seen forms used for data input but I have failed to find any
refernce to them in HELP or in the tutorials that I have found.
Where can I learn more?

we hada power surge .I didn`t saved my file is their a
way to recover it .I will appreciate your help
Thanks
Garry

I am developing an app using Excel objects.
I need to track the changes made in the cells while a user is working on an
excel sheet.
The only method I know is to use ActiveSheet and SelectionChanges and

I have 8 cells on the same row in one worksheet that I would like to be
automatically copied to a predefined area in one of 3 other worksheets
in my file depending on the number (1, 2 or 3)  entered in one cell
adjacent to these 8 cells.

Howdy folks,
I would like to know how to generate a range of number
(for example: 10000 to 19999) in excel without typing them
in each number into each cell one by one.

Can anyone help with the above message.  A spreadsheet is coming up with it
in an alert msgbox.  If i remove the the footer from print setup it solves
the problem.
Any ideas ?

i am doing 3 search fields. 1 for ID , 1 for Name and 1 for Yea
Joined.
the function for ID works. it returns me the values of it
-> =IF(ISNA(VLOOKUP(ID,Datas,3,FALSE)),"No Suc

I want to filter a colomn containing (nnnn)aaaa where n is a numeric and a
is an alpha character.  The colomn contains two names eg: cats or dogs
represented by the alpha characters above.
How do I sort the cats from the dogs?

Hi, is there a way to create a keyboard shortcut for the "Paste Value"
command?
I have tried using Customize Commands, but I can't figure out how to
create the keyboard short cut.