Thread: Code Cleanup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
P J H P J H is offline
external usenet poster
 
Posts: 1
Default Code Cleanup


Is there a way to make a short statement for the two ranges of cell
being selected, K14 through A14, and A13 through A1?

Sub GoToA1()
' Scroll cursor to cell A1. Starting at K14 allows for
' cells that are part of "Freeze Pane."

Range("K14").Select
Range("J14").Select
Range("I14").Select
Range("H14").Select
Range("G14").Select
Range("F14").Select
Range("E14").Select
Range("D14").Select
Range("C14").Select
Range("B14").Select
Range("A14").Select

Range("A13").Select
Range("A12").Select
Range("A11").Select
Range("A10").Select
Range("A9").Select
Range("A8").Select
Range("A7").Select
Range("A6").Select
Range("A5").Select
Range("A4").Select
Range("A3").Select
Range("A2").Select
Range("A1").Select

End Su

--
P J
-----------------------------------------------------------------------
P J H's Profile: http://www.hightechtalks.com/m89
View this thread: http://www.hightechtalks.com/t235157