VBA Code for Wrapping Text for Multiple Results and Preventing a Sheet from Scrolling

Understood Kev. Apologies, although it does have relevance because the result I'm trying to obtain will need the wrapping feature. Nevertheless, I'll start another thread.