I Created a spreadsheet with over 200 Worksheets inside and I wrote a macro
that basically formats each worksheet after I'm done put all the info that I
need (text, number, and graphs) I'm like half way through and I an error
telling me "No More New Fonts May Be Applied in this ...

How do I find all combinations of a 3 or 4 digit number in a lottery spreadsheet.  All 3/4 digits are contained in one cell.

Hi, I'm running into some serious bugs when I try to sort some
cells on a sheet. If all the cells contain simple text or
numbers, all is fine. But if any of the cells contains a
reference to another cell (outside of the sort range), the sort

Hi, all. Thank you in advance for your help with this problem that has
bugged me know for weeks.
My problem is this: my company sells only four basic categories of
items but, within each category, there can be as many as 15 variations.

I have a dataset in pivot/crosstab format. Can anybody think of an easy way
to take this dataset and turn it into a database-ready table?
That is to say, data is in the format:
Name          Jan      Feb      Mar

Some time ago I was told of a place inEXCEL that you can goto to reinstate
some program that were shut down by EXCEL for various reasons. Can someone
please tell me where that area is?
Thanks very much

How do I count the number of records within a date range.
eg 1/1/2003,1/5/2003,1/10/2004 Using countif between 1/1/2003 and 31/12/2003
= 2

Greetings All,
I set up a filter similar to Debra Dalgleish's Filter for Date Range,
using a numeric range instead.  This works fine.
There is student data on a sheet named "Students," and filter criteria

I need to count the occurance of only the largest duplicate number in a range
and return "TIE" in cells adjacent to those cells that have the largest
duplicate number.
Example

I need to send charts only ( not the supporting data) to 11 people by
e-mail.  About 15 charts per person.
But 4 people would get all the charts (about 80 charts).
I have the chart file prepared with a macro that creates the charts one at a

Is there a way to know the physical dimensions of a chart object on a
worksheet?  I have data in several worksheets and I would like all my
charts to be of the same size (obviously this means that data with a
smaller range of values will be more spread out than data with a larger

I have a problem which seems common, a spreadsheet increasing size from
4-5mb to 30mb. I have tried all the solutions I have seen (deleting non
used cells all the way to recreating the spreadsheet, copying cells).
This makes me thing the problem may be some of the formulae.

Excel 2K3 sp2, WinXP Pro sp2.
Tools | Options | General | Default File Location
or
Tools | Options | Save | AutoRecover Save Location

I couldn't find what I was looking for on contextures so I thought I'd
submit it here.
I have a small spreadsheet that does a very basic calculation. In this
spreadsheet I have a 2 column list. Column 1 has the name of the item and

How do I find all cells with formulas, Excel 2003. Thanks in advance.