Absolute cell referencing

Hi

Please kindly assist with my question below.

I am writing a code to merge cells together; I want the heading of my dataset to be fixed and to appear in all mergers. The table below (and document attached) might give an idea of what I am trying to achieve.

A B C
1 Like Dislike Advice
2 The environment Weather Improve service
3 Nothing Everything Not applicable





Merger 1: - Merging rows A:A with B:B

A1 & A2 & B1 & B2 & C1 & C2

(Like The environment Dislike Weather Advice Improve service)



Merger 1: Merging rows A:A with C:C

A1 & A3 & B1 & B3 & C1 & C3

(Like Nothing Dislike Everything Advice Not applicable)


I have already written a code to merge cells but I can not figure how to make row A:A fixed/absolute.

Regards


Phresh10