How does one go about inserting a comment into a cell in Excel using POWERSHELL?
Basically, I want to modify a cell so that I can add the comment property to it...
[I'm working on an audit form, and I want a short version of the error, and then the ability to however over the red triagle in the corner of the cell to display the full error...]
My code for selecting a cell looks like this:
$CurrentSheet.Cells.Item($ServerRow+1,$ServerCol) = $string
How do I add a comment, insert it into the cell in question, and make it visable?