title: Simple VBA selection: Selecting 5 cells to the right of the active cell
body: <p>I am trying to select and a row of 5 cells to the right (the selection should include my active cell) of my active cell. My current code is: </p>
  
  <pre><code>Sub SelectandCopy()
  '
  ' SelectandCopy Macro
  '
  ' Keyboard Shortcut: Ctrl+Shift+C
  '
  ActiveCell.CurrentRegion.Select
  Selection.Copy
  Windows("Study.xlsx").Activate
  End Sub
  </code></pre>
  
  <p>I do want not a specific range from my worksheet because I want to be able to make a selection of these data sets from anywhere within my worksheet. Any help would be greatly appreciated!!</p>
  
  <p>Would you use the Selection.Extend?</p>