Jon von der Heyden
MrExcel MVP, Moderator
- Joined
- Apr 6, 2004
- Messages
- 10,907
- Office Version
- 365
- Platform
- Windows
Hi,
When I use VBA to fetch comment data into a cell it wraps it. But it doesn't just wrap it because as soon as I unwrap it it puts in a tab symbol for each line break. Does anybody know of a VBA command to make it not do this?
I'm thinking that I could use substitute and unwrap but not sure if there's a better way. I tried comment.value instead of comment.text but it didn't work.
Cheers,
Jon
When I use VBA to fetch comment data into a cell it wraps it. But it doesn't just wrap it because as soon as I unwrap it it puts in a tab symbol for each line break. Does anybody know of a VBA command to make it not do this?
I'm thinking that I could use substitute and unwrap but not sure if there's a better way. I tried comment.value instead of comment.text but it didn't work.
Cheers,
Jon