Selection Cell in Microsoft Office Excel Using Macro

Example:

• To select a cell in ms excel (example cell will be selected is cell Z7):
  

  Sub nameOfSub()   Range("Z7").Select End Sub

• To select some cells in ms excel (example cells will be selected is cells D2 to Q10):
  

  Sub namaSub()   Range("D2:Q10").Select End Sub

Source: Tutorial Excel Indonesia: https://www.youtube.com/watch?v=RxAgtqr6YA4

Posted in: