Thread: Forgot where I put the Select all VB code, help.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pgarcia pgarcia is offline
external usenet poster
  
Posts: 304
Default Forgot where I put the Select all VB code, help.
Hello all,
What is the code that will select A2:E2, shift+down arrow to last cell then
shift+up arrow?

Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlUp)).Select

But this just goes down 1 cell, I need to go to the last cell in A:E.
Thanks
Reply With QuoteReply With Quote