Insert comment from multiple Cells Range

Hi, I'm kinda new to the VBA World, and I've written a little code that inserts a comment on to a cell (B2),
but the comment must come from multiple cells range (H1:H45)

Please Login or Register  to view this content.

H1:H45 =

Please Login or Register  to view this content.

I've tried inumerous ways to make this, I've been searching for an hour now, and haven't found a solution, does anyone know a way?
Thanks.

John.

Hi & welcome to the board.
Try

Please Login or Register  to view this content.

I worked perfectly!! Thank you so much <3

Glad to help & thanks for the feedback