I'm using the sum function to add 6 numbers in excel. In one particular
target cell, it refuses to print the answer; instead it prints the formula. I
- Jun 04 Wed 2008 20:44
Why does formula show rather than results (not in text format)
- Jun 04 Wed 2008 20:44
How do I add business days to a date field, no weekends?
I'm creating an excel spreadsheet and need to add business days only. If
cell a1 is todays date (3/20/06), how do I make cell b1 equal a1 5 business
- Jun 04 Wed 2008 20:44
Cell sizing in a Vlookup formula to fit information.
Is it possible for a cell to automatically size itself by height to fit the
information pulled into said cell by a VLookup formula. The information in
- Jun 04 Wed 2008 20:44
Comparing multiple columns
- Jun 04 Wed 2008 20:44
Problem setting SeriesCollections source range
In VB6 sp4, I'm having problems setting the SeriesCollection() range. The
end row of the range will be dependent on the number of bins the user
- Jun 04 Wed 2008 20:44
Finding height between high points
Hi,
- Jun 04 Wed 2008 20:44
VLOOKUP Function
Can you enter multiple values in the quot;Lookup_Valuequot;. I have 3 worksheet, on
sheet 1, I have cell J9 that looks at I9 and a data table on sheet 3 which
- Jun 04 Wed 2008 20:44
combining two formulas
- Jun 04 Wed 2008 20:44
Looking up values,problem: they occure multiple times
- Jun 04 Wed 2008 20:44
Automatic and manual calculations
Rather than setting application.calculation to xlAutomatic (or using
application.calculate), you might just use ActiveSheet.Calculate as necessary

