Oooops sorry this just selects the last cell only
ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell) .Activate
"Cathy Myers" wrote in message
...
Hi,

Is there any way to programmatically control how Ctrl+End
works? My spreadsheet pulls from a database, and I'd like
for Ctrl+End to take them to the last cell to which data
has been returned. Thanks in advance.

Yours,
C.M.