I working on a complex spreasheet where some of the entries are NA.
- Apr 21 Sat 2007 20:36
How do I create a formula that makes text in a cell = 0
- Apr 21 Sat 2007 20:36
Scrolling too fast on one sheet
The scrollbar moves about an inch and the rows scroll about 3500 just in one
sheet. Is there a way to adjust or fix that?
- Apr 21 Sat 2007 20:36
Help with a complicated search function in Excel
I have a worksheet that has salespeople's names in column B and sales totals
in column AJ. Obviously these totals change over time. I would like to had
- Apr 21 Sat 2007 20:36
Max Value in a Row
- Apr 21 Sat 2007 20:36
To get values into an array
I need a function to check a Column of data and check if it is quot;Feasiblequot; or
quot;Unfeasiblequot;. In the next column of data the is measurements. I need to get
- Apr 21 Sat 2007 20:36
How do I stop line on chart
When I am using VB with a Button to (copy, paste special-values) blanks, the
chart shows the blanks as zeros unless I manually delete all the blank
- Apr 21 Sat 2007 20:36
Not enough system resources to display completely.
I get this error message every time I view a particular worksheet in my
spreadsheet. The spreadsheet is quite large (35 MB), so I realize that I must
- Apr 21 Sat 2007 20:36
How can I create an AutoFormat row color change for a value in a c
I use Microsoft Excel to keep track of our inventory. I have a formula on my
quot;Quantity to Orderquot; column that allows the program to automatically change
- Apr 21 Sat 2007 20:36
e-mailing one worksheet
We have a workbook with multiple worksheets, we want to e-mail the individual
worksheets to different people. The microsoft site has a method but it does
- Apr 21 Sat 2007 20:36
I am trying to change Smith, John to John Smith
The tricky part about this is the that it must be done in only 2 cells, all
of the example given in the Excel tutorials are using one cell for each name,

