Forum Discussion
serious_sam13
Feb 24, 2021Copper Contributor
Reference Cell with notes
Is there a way to reference all data (including notes and/or comments) from a cell on one sheet to a cell on another sheet. For example, on Sheet1, Cell A1 includes data and a note. If I use someth...
JLPiraux
Sep 20, 2023Copper Contributor
serious_sam13
I just created a function to retrieve the note attached to a cell:
Public Function GetNote(ThisCell As Range) As String
GetNote = ThisCell.NoteText
End Function