View Single Post
 
Old 12-20-2021, 12:04 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

With a lot of trial and many errors i found this works.

Code:
    Intersect(ActiveCell.EntireRow, tblColumns("Notes").Range).Comment.Shape.Width = 600
    Intersect(ActiveCell.EntireRow, tblColumns("Notes").Range).Comment.Shape.Height = 800
Reply With Quote