title: VBA EXCEL Setting print range based on date
body: <p>Basically i have worksheet that gets updated on daily basis and want to be able to set it up to automatically print each week. Each week lets say Friday it will print the last 7 days worth of data (7 days = 7 last rows).</p>
  
  <p>I have managed with the help of task scheduler that runs a .vbs macro to automatically open the excel worksheet, print and then close.</p>
  
  <p>How do i go about adding the last step to this automation which is to print the current weeks data only and not the whole worksheet.</p>
  
  <p>So i need specifiable column range and for the row range something to be used in conjunction with TODAY function of excel perhaps? if that's even possible.</p>