Thread: ctrl-end in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default ctrl-end in VBA

try

Sub sce()
ActiveSheet.UsedRange.Select
End Sub
--
Don Guillett
SalesAid Software

"Torstein S. Johnsen" wrote in message
...
I want to select a range from C3 to "last cell" in many different

workbooks.
I know have to do this manually with SHIFT-CTRL-END but is there a simple
way to do this with VBÀ?

Torstein Johnsen