Getting a cell reference
Instead of using SendKeys, which can be unreliable in my experience,
(e.g. the keystrokes may get sent to the wrong window) try:
<variable = ActiveCell.SpecialCells(xlCellTypeLastCell).Addres s
You don't need to move to the last cell just to get its address,
but if you need to do so you can say
ActiveCell.SpecialCells(xlCellTypeLastCell).Select
Desmond wrote:
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 )
|