Retrieving comment using range name

[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

 

[Guest]

Set testrng = Range("A3:A4", "C3:C4")
comment1 = testrng(1).Comment.Text
....
commentn = testrng(n).Comment.Text

Stefi

„topola†ezt írta:

 

[Bryan Hessey]

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