Forum Discussion
Don't think you want to use "Range". Thats for capturing a number of cells.
Change range to "Cell(x,y)" instead.
When you say comments, is this just standard text contained in a cell or is it like a tooltip type popout comment?
- sudit9 years agoNew Contributor
Hi Colin,
I did try with Cell(x,y) but it didnt work out.
Also as you rightly guessed Comment is like a tooltip popup comment.
- Colin_McCrae9 years agoCommunity Hero
Think your answer might be a combination of both answers.
For an individual cell, you should probably use "Cell" rather than "Range" but what joseph_michaud says about your syntax is probably right. I've never tried to retrieve comment type text from Excel before so not sure ....
(I guess "Range" will work if you give it a range of a single cell, but suspect "Cell" would make more sense)
- dmiscannon9 years agoFrequent Contributor
The answer provided by joseph_michaud worked for me. Have you tried it yet?
Related Content
- 2 months agoStoplight
- 2 years agoDavid_Be
- 6 years agolalitha123
Recent Discussions
- 6 hours agoashly