Hi,

Can someone help me figure out what I'm doing wrong. I need to identify the
last cell reference in a "Used Range." Using the following statement finds
the last cell okay
Sendkeys "^{END}"
but how do I get the reference so I can assign it to a variable? (While the
cell does appear to be selected, the statement
<variable=ActiveCell.Address
returns the reference to the starting cell, not the end cell.

What am I doing wrong?

Thanks,

--
Des )