How do I Loop Dynamic Comments Placed Dynamically in different cells

[e4excel]

How Do I Loop Dynamic Comments fetching info from consecutive cells and to be displayed in seperate cells

How do I Loop Dynamic Comments Placed Dynamically in different cells

I need to display comments in 2 cells in a particular column lets say column J..

The First cell in which I need to display a comment is always going to be Row = 8 i.e. J8 and the the other cell is not fixed and be always changing but it will be again in the column J..

Now, using formulas I am putting these values of the First Cells Row in the cell J1 as 8 &
the Second Cells Row in the consecutive cell J2 as lets say 68...

Now that was about the cell Addresses where I wanted the Comments to be shown..

Also, the Comment text is Dynamic and is to be fetched from consecutive cells i.e K1 and K2..

K1 has the text for the Opening Balance
K2 has the text for the Closing Balance..

How do I write a Single Loop which will fetch the Comment Text from Consecutive cells and also then display the comments in different cells. lets say like cell J8 and J68..

Cell J1 ===> contains the Row No of the First Cell which wil have comment i.e. 8
Cell J2 ===> contains the Row No of the First Cell which wil have comment i.e. 68

CELL J8 --> CommentText is contained in the Cell K1
CELL J68 --> CommentText is contained in the Cell K2

Though, the Cell J8 would always be the First cell to have Comment the Second cell can be any cell rather any row depending on what comes in the cell J2..

Please Login or Register  to view this content.

I also need some help in using the above Line of Code if a cell already has a comment and if does not have a comment , then how do I address the error for the 2 conditions?

Warm Regards
e4excel

[e4excel]

Dear Forum,

Finally, got it..!

I still need some help in using the below Line of Code if a cell already has a comment and if does not have a comment , then how do I address the error for the 2 conditions?

Please Login or Register  to view this content.

I was making a stupid mistake of putting the Row =1 in the loop..

Please Login or Register  to view this content.

Warm Regards
e4excel