title: ActiveSheet.copy question (vba, excel)
body: <p>Hey guys,
  I have a small problem.
  I have a sheet called "main" that takes values from another files sheet called "data".
  When I active the "ActiveSheet.copy" (in the "main" file) it copies the sheet but with the cells links. 
  I want to know if there is any way to copy just the values of the sheet?</p>
  
  <p>Second, my "main" sheet has some merged cells so even if i manually copy &amp; paste the sheets by selecting a range it can't be copied due to the merged cells.</p>
  
  <p>P.S. I hope I explained myself well - as you can see English is not my first language.</p>
  
  <p>Thank you</p>