how can i retrive all the sheets names (or Caption) available in a workbook
and how can i find if a sheet exsist on the workbook
thak all it's a great newsgroup

hi, anyone got any links or pointers to more detailed custom formatting or
conditional formattings which use a formula to determine...
trying to find out what are those ; @ [] etc etc in custom formatting
does... trying to learn them.

I have an Excel file (workbook) that contains several worksheet. Is there
any macro command that I can use to allow users to just save (save as) one
of the worksheet (say WorksheetA) to a disket in
1) Floppy Disk A

Hi... I need a little help in reversing a formula, as follows:
Column A is Gross, B is Fica, C is Medicare, D is Fed, E is State, F is NET.
Columns B thru F are individual percentages of A (the Gross) - F is the Net,
which takes the total sum of the percent columns, adding B thru E ...

I need to sort columns, except for the first two, and the last.  Just
the ones in the middle.  A column will be added in the middle when
another macro is run to add.
Thanks,

Hi.  Working on a macro subtotal in which the amount if data is
variable.  Let me elaborate.  I am creating a macro to organize a
report from data which is variable.  While all my columns of data
remain constant (so it's easy to format and pretty up the report), the

How can I format a cell depending on the value of another cell?
Many thanks.
Wilfried

Is there a way to automatically add/show rows that have data? I have a
data entry sheet. Then I have a report. The report pulls data from the
entry sheet. If there is no data for a specific line/row item, is there
a way to automatically hide or not show the row(s) with no data? ...

Probably so simple, I'm embarrased to ask.
I put in a formula such that in a cell there would be the SUM of a column of
numbers.
Pretty sure I did it correctly.

How do I lock certain cells from getting edited accidentally, while I work on
other cells in the same sheet

How can I make all of the cells the same size?

Thanks
Colin

Hi all,
Kindly assist on the following:
eg: 10.00 per 1st 5 items, 5.00 per every additional 5 items
Thus, if the total is 20 items, then the answer would be 20.00

How can you multiply 58:41:00 times $200 per hour?
I guess you have to change the 58:41 into an integer and decimal
format but I don't know how to do that?
Also, if you have a long list of times, what is the best way to check

How do I activate Text to voice in EXCEL 2007.
I have no trouble in Office 2003...but no luck so far in 2007
Yhanks