•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to run Macro on only selected cells?
I have macro that changes to size of comments. Can anyone help me to adjust it so it only runs on selected cells? Much appreciated!
Sub ResizeSelectedComments() Dim xComment As Comment ' Set desired dimensions Const xWidth = 713 Const xHeight = 355 For Each xComment In Application.ActiveSheet.Comments With xComment.Shape .Width = xWidth .Height = xHeight End With Next End Sub [link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#no-code spreadsheet solutions
#Excel alternatives
#Macro
#selected cells
#ResizeSelectedComments
#comments
#dimensions
#xComment
#ActiveSheet
#Width
#Height
#Sub
#Comment
#For Each