Retrieving comment using range name

  • Thread starter Thread starter topola
  • Start date Start date
T

topola

I have singular cells in different places referenced by their range
names. Is there a way to get the comments corresponding to the
referenced ranges (singular cells)?
Thanks in advance,
Tomek
 
Set testrng = Range("A3:A4", "C3:C4")
comment1 = testrng(1).Comment.Text
....
commentn = testrng(n).Comment.Text

Stefi

„topola†ezt írta:
 
did you mean,

asin having a cell C4 named Myrange,

a cell C5 containing the word Myrange

and a cell C5 having the formula =Indirect(C5)

which reflects the data from cell C4, the single cell named rang
referenced in C5
 
Back
Top