Attempting to AutoFit Row on another Worksheet

[dhoff]

Greetings All,

I've been attempting to deliver a solution involving some basic VBA (most of the work is being done with formulas). I'm looking at 3 worksheets (AppendixA, AppendixB and Summary) - there also is a Data worksheet, but that contains all my tables and is hidden. The users will make selections in Appendix A and this will translate into numeric values in Appendix B (being handled) and pass entered text into cells on the Summary worksheet.
The catch is allowing users to enter their text in Comments in Appendix A and having the corresponding cells in Summary autofit their row height correctly.
I'm looking to have this row autofit performed automatically (SelectionChange) as each Comment cell in AppendixA is updated (there are 8 in total).
My questions are: (1) where should this be placed (AppendixA or Module1 or ThisWorkbook)? and (2) exactly how do I get the Rows.AutoFit to call properly?

What I have so far (which is not working) located in AppendixA's code:

Please Login or Register  to view this content.

[Winon]

Hello dhoff,

Welcome to the Forum.

Deleted my suggestion as it won't work.

I'll be back with a ready solution.

[Winon]

Hello dhoff,


Please try this Code:

Please Login or Register  to view this content.

Also see the "Please consider" note at the bottom of this post.