Moving cell contents as comments-to be part of big routine

[KK1234]

Hi all,
I have this code and it works fine.
Select the cell then press commandbutton. This will copy contents of cell as comments.
Works well .

Please Login or Register  to view this content.

Now I want to incorporate this code by calling it at the end of a big code.

It is a very small modification , but I am not going anywhere and need help.
Please scroll to the last few lines of this big code, where I have highlighted in red where I request help

Please Login or Register  to view this content.

Request some help please.
Kind regards

[Izandol]

You may change comment routine to this:

Please Login or Register  to view this content.

Then you may call this:

Please Login or Register  to view this content.

[KK1234]

Hi Izandol,
Really thanks for a quick help and a perfect solution.
It is indeed a 5 star reply and help.
It works Great.
Thanks again
Kind regards

[KK1234]

Hi Izandol,
Apology to to re-open the thread.
One more question.
What would be the code if I want comments to appear in row G1.
That is copy text from Q1 and show it as comments in G1.
Is it possible?
Please help
Kind regards

Please Login or Register  to view this content.