VBA - detect if text does not fit in the first merged cell

[omnivl]

I have text string that is produced from code that can vary from approx 250 words to 1000 words.
In my sheet i have two merged cell areas. I need to detect if the text string is to big to show in the first merged area, if it is then it needs to split and the last viewable word and move the remainder of the text string to the second merged area.

Any help would be much appreciated

 

[PhilS2520]

Hi Omni love,

Wow! This is a tall order. With a cursory reading I could find these issues.

A) What will happen if you change the screen resolution and now your worksheet will look differently.

B) How can a code determine the location of the last visible cell?

C) Merged cell’s should be avoided like the plague. Look at this https://www.techrepublic.com/blog/10-things/10-ways-to-keep-excel-from-biting-you-in-the-butt/

You can search using the search term “avoid merged cells in excel” and you can see all sorts of horror stories, and alternatives to merged cells.

Best of luck in developing such Code. If you succeed I’d like to check it out.