Exactly how did you want to get the comment from B74:J80... that is some 63
cells... did you want to concatenate **all** of them into a single piece of
text (and, if so, how... column by column then row by row)?

--
Rick (MVP - Excel)


"N1KO" wrote in message
...
Hi,

I need to make put a comment box on a cell but the actual comment comes
from
a range of cells on a different sheet.

The range will always be ("B74:J80") but the sheet name will change. The
sheet name will always be in cell J3 of the sheet.

So i need the comment box to be in cell J13 with the comment being from
B74:J80 on another sheet, the sheets name will be in cell J3.

Will I need to create a variable for the range?

Any help on this will be hugely appreciated.

N1KO