title: Excel VBA range selection based on date range
body: <p>I´m in early beginning of VBA learning . Need simple code for selecting a range of cell to sum them.   </p>
  
  <p>The thing is I manage to found many examples but none of them seems to work. So task is to select range of cells from B:xx to Q:xx if A:xx cell contains date between dd1.mm1.yy1 and dd2.mm2.yy2. That needs to be done in 9 sheets in same workbook  </p>
  
  <p>pic of example</p>
  
  <p><a href="https://i.stack.imgur.com/nq8sR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nq8sR.png" alt="enter image description here"></a></p>