I have taken an Example from Live Scenario, where you want to send an Email on a daily basis based on certain conditions and cafeterias.Example: Let’s assume that You are working as a Team Lead. You are responsible to assign Task to each member with a dead-line (Date of Completion).Usually, if you add more text to a single cell, and Wrap Text is turned on, the row height automatically adjusts, to fit the text. To test the code, make a change to the text in the named merged cells, then press Enter. Is this something that you’ll use in your workbooks? When the cells are merged in row 10, the row height has to be manually adjusted when the text changes. Sub Sample1() Dim i As Long, j As Long, cnt As Long Dim buf() As String, swap As String cnt = Worksheets. Count Re Dim buf(cnt) '[NV[gzɓ For i = 1 To cnt buf(i) = Worksheets(i). Occasionally though, you might have no choice but to use one or more merged cells on a worksheet.
And if you forget to adjust the row height, you might print the order form, while key instructions are hidden.
The Excel Template which I have prepared looks like this: Follow the below Steps to Set up this Macro in your System: Step 1. To know How to Schedule a Task in Windows Read this article.