I wonder if someone can help me out on this.
I have one excel spreadsheet (1) in which I make some calculation
(Cells G1:AH500) for some given starting values (A1:F500). In a
adjacent spreadsheet (2) I make other types of calculations, into whic

I have a macro I would like to run when a partiuclar sheet is selected
in a workbook but cant find where that is covered.  I would also like
that same macro to run when the sheet is closed and another sheet is
opened.   Is there such a command in Excel.  TIA

Is there a way to format a text box on a user form to only allow date
entries ie: mm/dd/yy or mm/dd/yyyy?

A    B    C
0    15000    10%
15001    35000    15%
35001        20%

How Can I update my numbered list (S.No) after Filtering the list?
Like:
1.    A
2.    B

In Word it is possible to have column breaks on pages.  That is, if the page
was set to have 2 columns, inserting large text would flow in the 2nd column
instead on the next page.  What I like to know, is it possible in Excel to
flow inserted text/data so that instead of it ...

can excel reorder lines  of text from a txt file?
example would be....
joe
john

Is there a way to Fill-Down or Fill-Right in Excel without affecting
borders?   I have written macros to do such things but I end up using
Excel on so many computers that I am compelled to see if there is a
simpiler solution?

Thanks in advance..I am trying to design a Invoice type document in
Excell. I have created a drop down list containg the names of various
products. When I select a product from this list I would like it also to
make reference to the price per unit of this product and I would like ...

I am trying to filter a list over nearly 4000 email addresses. Some of the
entries are bogus and do not contain an "@" symbol. Is there an easy way to
find and sort by these cells so I can delete them?
Thanks!

Web Page Hyperlinks/How do you make a list URL's active?
I have a whole list of many URL's in Excel and I would like to mak
them active links so that when you press on them, you go to thei
respective web page.  I can do each one, one by one, by pressing F2 o

Using Excel XP.
I have the following sample worksheet:
                 A
--------------------

I have created a User Form to enter data into an Excel Database using
text boxes.  For one field (textbox) I would like to limit the user
input to three names, say AA, BB or CC.
I know how to do it on the worksheet and it works just fine.  I can't

First and foremost, I've just spent some time reading the posts in this ng and
have learned more than a few tricks, that as a novice, I would've never been
able to complete. With that in mind a big thanks goes out to the many
contributors here.

Just wondering......
Theres not one website to discuss excel game programming.
I was thining the same about SAS programming
I think programming games to work under excel would be a bit fun yes?