| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| Question for use of offset and range | Excel Worksheet Functions | |||
| Question regarding dynamic range setting | Excel Worksheet Functions | |||
| can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Linear Mode
