title: Run VBA format code on all sheets with different number of rows
body: <p>VBA noob here needs a little bit of assistance.  I cannot seem to find a solution or get something to work.</p>
  
  <p>I've tried to simplify it as much as I could to get a proof of concept.</p>
  
  <p>The basic idea is to format one cell (A1 say) with all borders, copy that format down across all data in the first sheet (A1:C10 for example), then do the same with data in subsequent sheets.  What I'm struggling with is that subsequent sheets all have a different number of rows and anything I try just formats the additional sheets to the (A1:C10) of the original even if there is no data present.</p>
  
  <p>Any help would be greatly appreciated.</p>