VBA Macro to Merge and Unmerge Cells - Excel VBA Example 

There is already a tutorial to remove duplicate. Please check following link : ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wIVNLRnyEuY.html

You can use dollor sign ($) to make any range fixed. For example, if you want to fix A1:A10, then you can write\use $A$1:$A$10....... one more example, if you want to sum data in Range A1:A10 and keep it fixed then use formula as =SUM($A$1:$A$10).......I hope this is helpful...for any other question write to exceldestination@gmail.com