title: Excel Macro - Take a snapshot of Particular Range
body: <p>I have come around a very strange requirement in my Excel Dashboard.</p>
  
  <blockquote>
    <p>I have a some data in a Range in a particular sheet. I need to take a
    snapshot of it and display it as an Image in all other sheets at top.</p>
  </blockquote>
  
  <p>I know I can simply copy &amp; paste the range but that kind of Header is creating some issues while hiding columns on the sheets.</p>
  
  <p>Any solution/trick for that same?</p>