Professor Excel

Comments 5

  1. Rayden

    Hi… i extract the comments but when i put in a new input on the comments .. its not auto generate even tho under options calculation is put under “automatic”

    • Henrik

      Hi Rayden,
      yes, that’s a problem. Usually it works if you hold Ctrl + Alt and press F9 on the keyboard to force a full calculation.
      Best regards,

  2. Mr. Owen Sneath

    Thanks!… your page helped me figure out how to get the comment out using Cells()… I was trying String=Cells().Comment… didn’t realize I needed to add .text… Saved me a lot – Thanks!

  3. Greg Stricker

    I need to extract comments to cells in Excel 2019. I downloaded Professor Excel, but cannot figure out how to use it for this. If I type =PROFEXCommentText(cell reference) in the cell where I want the comment text to appear, it tells me “there’s a problem with this formula”. What am I doing wrong?

    • Henrik Schiffner

      Hi Greg,
      I’ve sent you an e-mail. Let’s figure it out.
      Best regards,

Leave a comment

%d bloggers like this: