Consider the merged cell value: Using the code below, you can perform VBA Paste Values Only for merged cells. This results in the output as shown below: