I need to write a VB script in excel that tells me which cell has focus.
Here's what I want to happen: I want to click on a cell, then push a
pushbutton that will copy the contents of the cell to another worksheet.

I can copy just fine, I just don't know how to determine which cell to copy.

Msgbox Activecell.Address

Regards

Trevor


"ragnarok" wrote in message
...
I need to write a VB script in excel that tells me which cell has focus.
Here's what I want to happen: I want to click on a cell, then push a
pushbutton that will copy the contents of the cell to another worksheet.

I can copy just fine, I just don't know how to determine which cell to
copy.