title: How to change values of range in excel vba
body: <p>I want to change value of range (Source) and paste to to another range (destination) in excel vba. Please note that forward slashes may vary in source. </p>
  
  <p>For instance I want to do like this but from vba excel:
  <a href="https://i.stack.imgur.com/tZm77.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tZm77.png" alt="enter image description here"></a></p>
  
  <p><strong>psedu code:</strong></p>
  
  <p>ThisWorkbook.Sheets("Sheet1").Range(A1,A4).Value = Replace source string before last forward with variable.</p>
  
  <p>variable = "C:Destination\"</p>
  
  <p>Basically I am amending values of Source and want to paste in destination.</p>
  
  <p><strong>This Code works but paste same values from source to destination</strong></p>
  
  <p>ThisWorkbook.Sheets("Sheet1").Range(A1,A4).Value = ThisWorkbook.Sheets("Sheet1").Range(B1,B4).Value</p>
  
  <p>Please help in am new to VBA, Thanks in advance. </p>