Getting a cell reference
 

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 )

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 )

Getting a cell reference
 

This was very helpful, thank you!

If, however, I use the "Find" method for instance to locate information and
then need to get that cell reference, how would I do that?

--
Des


"Andrew Taylor" wrote:

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 )