View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
N1KO N1KO is offline
external usenet poster
 
Posts: 60
Default Comment Box to include a range of cells

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