Get comment data

[Jon von der Heyden]

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

 

[Norie]

Jon

Perhaps you could use the Clean worksheet function in code via WorksheetFunction?

 

[Jon von der Heyden]

Yep, that'll do it. Thanks Norie!