C
CLR
Hi All.......
Someone, (I don't remember who), sometime, (I don't remember when) was kind
enough to post this fine UDF.
Function copycomment(r As Range)
Application.Volatile
Dim whereami As Range
Set whereami = Application.Caller
If whereami.Comment Is Nothing Then
Else
whereami.Comment.Delete
End If
whereami.AddComment Text:=r.Value
copycomment = ""
End Function
It works great, but now I have a user who wishes to also retain the
FORMATTING from the copied cell as well as the text......is this possible?
TIA
Vaya con Dios,
Chuck, CABGx3
Someone, (I don't remember who), sometime, (I don't remember when) was kind
enough to post this fine UDF.
Function copycomment(r As Range)
Application.Volatile
Dim whereami As Range
Set whereami = Application.Caller
If whereami.Comment Is Nothing Then
Else
whereami.Comment.Delete
End If
whereami.AddComment Text:=r.Value
copycomment = ""
End Function
It works great, but now I have a user who wishes to also retain the
FORMATTING from the copied cell as well as the text......is this possible?
TIA
Vaya con Dios,
Chuck, CABGx3