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.