|
Retrieving comment using range name
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 |
Retrieving comment using range name
Set testrng = Range("A3:A4", "C3:C4") comment1 = testrng(1).Comment.Text .... commentn = testrng(n).Comment.Text Stefi €˛topola€¯ ezt Ć*rta: 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 |
Retrieving comment using range name
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 range referenced in C5 topola Wrote: 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 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=477810 |
| All times are GMT +1. The time now is 07:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com