Rick,
That's the frustrating part. I can see the information I want in the upper
left corner of the worksheet, but I can't use it in calculations.
I plan to display list of items on a workwheet where the user can scroll
through them using the cursor or arrows.
For each item there is an associated description that I want to display in a
separate part of the worksheet. If I could get the row and column of the
cell that the user is looking at at the moment, I could use that information
to look up the description.
I'm surprised that there isn't an Excel function that does this.
Thanks again,
Jim

"Rick Rothstein (MVP - VB)" wrote:

I am working in Excel and don't know much about Visual Basic or Macros.
Rick has given me a response which would probably help me if I did, but
the
fact is I can't make it work.

ROW() or COLUMN() just give the coordinates of the cell that the formula
is
written in.
I want to know the current coordinates of the cell that the "cursor" is
in.
The values should change as I use the arrows to move around the worksheet.

I think you will need to tell us more than you have about how you plan to
use this information. The reason your question, as stated so far, is
confusing is that you seem to want to "see" the active cell's row and column
while in the worksheet... but "active cell" is always being displayed in the
field located next to the formula bar, so you have to have something
"deeper" in mind with your question.... I think we are just having trouble
seeing what it is.

Rick