I'm using a function at the moment to copy the comment text from cells, but would like to Change it a Little.
At the Moment I have:
There are 3 Basic Groups that the comments refer to, eg: If a comment is a 1,4,11,14 it's Group A. 2,5,12,15 are Group B, etc...![]()
Function CC(cel As Range) CC = cel.Comment.Text End Function
I guess it would be something like
I can quite figure out how to formulate it correctly though.. Can anyone help??![]()
If CC = (1,4,11,14) then "A" else if cc = (2,5,12,15) then "B"
Thanks
Michael











LinkBack URL
About LinkBacks
Register To Reply

Bookmarks