Equivalent Method to Control + END
 

Folks,

I used to know this at one time but I've forgotten.

What is the code I'd use to simulate what I get when I use the Control + End
key combination on a worksheet?

TIA
Alice

Equivalent Method to Control + END
 

ActiveSheet.Range("a1").Select

--
Michael Hopwood (Phobos)


"Wayne Smith" wrote in message
...
Folks,

I used to know this at one time but I've forgotten.

What is the code I'd use to simulate what I get when I use the Control +
End
key combination on a worksheet?

TIA
Alice

Equivalent Method to Control + END
 

Alice,


ActiveCell.SpecialCells(xlLastCell).Select

?

use the macro recorder to recor the ctrl + ENd action.

Cesar



"Wayne Smith" wrote in message
...
Folks,

I used to know this at one time but I've forgotten.

What is the code I'd use to simulate what I get when I use the Control +
End
key combination on a worksheet?

TIA
Alice

Equivalent Method to Control + END
 

That takes you to the last cell, so if the worksheet is blank it selects A1.

--
Michael Hopwood (Phobos)


"Cesar Zapata" wrote in message
...
Alice,


ActiveCell.SpecialCells(xlLastCell).Select

?

use the macro recorder to recor the ctrl + ENd action.

Cesar



"Wayne Smith" wrote in message
...
Folks,

I used to know this at one time but I've forgotten.

What is the code I'd use to simulate what I get when I use the Control +
End
key combination on a worksheet?

TIA
Alice

Equivalent Method to Control + END
 

try
ActiveCell.SpecialCells(xlLastCell).Select

--
Don Guillett
SalesAid Software

"Wayne Smith" wrote in message
...
Folks,

I used to know this at one time but I've forgotten.

What is the code I'd use to simulate what I get when I use the Control +
End
key combination on a worksheet?

TIA
Alice

Equivalent Method to Control + END
 

Sorry, ignore my post, I mis-read your original post.

--
Michael Hopwood (Phobos)


"Michael Hopwood" wrote in message
...
ActiveSheet.Range("a1").Select

--
Michael Hopwood (Phobos)


"Wayne Smith" wrote in message
...
Folks,

I used to know this at one time but I've forgotten.

What is the code I'd use to simulate what I get when I use the Control +
End
key combination on a worksheet?

TIA
Alice

Equivalent Method to Control + END
 

Sorry Cesar, I mis-read the original post, you are correct of course.

--
Michael Hopwood (Phobos)


"Michael Hopwood" wrote in message
...
That takes you to the last cell, so if the worksheet is blank it selects
A1.

--
Michael Hopwood (Phobos)


"Cesar Zapata" wrote in message
...
Alice,


ActiveCell.SpecialCells(xlLastCell).Select

?

use the macro recorder to recor the ctrl + ENd action.

Cesar



"Wayne Smith" wrote in message
...
Folks,

I used to know this at one time but I've forgotten.

What is the code I'd use to simulate what I get when I use the Control
+
End
key combination on a worksheet?

TIA
Alice