I have around 53,000 rows of data with columns A-I.  The first five rows
for example have data for a particular student... STUDENT A.  Rows 6
through 15 have data about another student... STUDENT B, and so forth.
Each column per student has the same data in it with the exception of

I have this particular piece of code in an application created on
Excel2000:
. . . . .
.range("B" & finger).PasteSpecial xlPasteValues

I have created a workbook with two sheets in it. I enter all my order
in sheet one and the sheet two totals them. The column on my sheets ar
as follow?.
Sheet one

When I use a function I only see the function and not the result.
For example
=now() gives =now(
--

I am looking to change the background colour of a cell when a specifi
formula returns false. Any help on this would be greatly appreciated.
Regards,
Johnny

I am using Excel 97 on NT and have a command button on a sheet to whic
I attached a macro for copying the sheet to a new workbook, deletin
specific columns and other unnecessary info, and saving the new book t
a network drive under a name with today's date for emailing to anothe

How do I make the input box area where you put text in, BIGGER so that you see more of it, like multi-line?

I have a chart that is supposed to be sorted with respect to the
values in the first column. The problem is that those values are
not alphabetically raising.
Suppose the values are "great", "well", "ok", "bad". How can i get

I've got a column of numbers that's height changes everytime I add
more data.  I would like to find the difference between the top number
and the bottom number and have that result in a cell above that
column.  How can I write a formula that will adjust to the changing

I'm trying to define a relative range of cells in a macro and copy the
formulas from that range to the next row below using R1C1 cell
addressing style.   I can't seem to get the the thing to go.  Anyone
know how?

Looking for a way to log (on a sheet within a workbook) all users that
access the spreadsheet and when.
Is this possible using wither VBA or other method?
Many thanks.

Is it possible to show supersript in a text entry in excel for example the
symbol for H2O or Cubic metres - m3??
TIA
Mick

Can any1 help to sort out the error....
I am trying to use DSUM formula. I want to retrieve
Total Amount from the list of 'Sales' (sheet 1) for each
customer in a separate sheet.....(Sheet2)... All customer

I'm having trouble with comments resizing themselves to weird shapes --
sometimes much larger than needed; other times collapsed completely. Is this
a known "feeture"? Is there an easy way to automatically resize (via marco
perhaps)?  Many thanks...   ./RN

Through VBA I need to enter the Counta formula in each of 50
worksheets in a workbook to count the number of entries therein minus
the header.
I then want to list on a main sheet the tab name of each sheet and the