title: Unpivot code set returns an error in Resize Ubound function
body: <p>I'm trying to unpivot an array of data. I was able to do this before from a slightly different Source data, thanks to our good sir's help mr. Tim Williams who answered my previous question on this ( <a href="https://stackoverflow.com/questions/64615412/how-to-unpivot-a-fixed-number-of-columns-with-vba-just-like-power-query">Link to my previous question</a>),  however, now i'm using a slightly different source data.</p>
  <p>I was pretty sure that I have to only change the number of columns that will be fixed in</p>
  <pre><code>p = UnPivotData(ThisWorkbook.Sheets(&quot;Projects Data&quot;).Range(&quot;A1&quot;).CurrentRegion, _
      114, True, True)
  </code></pre>
  <p>i.e. 114. But for some reason I get an error in this part</p>
  <pre><code>.Range(&quot;A1&quot;).Resize(UBound(p, 1), UBound(p, 2)).Value = p 
  </code></pre>
  <p>It also does work for some couple of lines and after that the error kicks in. I'm not sure what seem to be the error here. I've been trying to work on this for two days and I'm sleep deprived and frustrated,so as usual, I would really be very happy and appreciate your help on this.</p>
  <p><a href="https://drive.google.com/file/d/1kckguoYeG5-ERMRPWvgwgXrQC-kZAiTi/view?usp=sharing" rel="nofollow noreferrer">Here's an extract of the file that i'm working on with it's code.</a></p>