- Jan 7, 2019
- Office Version
Greetings. I have a macro that I need the height adjusted based on a small portion of text found in a cell. The cells had to be merged due to text I have within the cell, so I cannot use autofill. I can come up the a macro if the cells will never shift up or down, but that is not an option.. The range will start on A1 and will go down the rows until the end of the document. For example it would search for a cell Value = ("*CAT I*") then the height would be adjusted to 67.5 only for that cells containing that cell value. I have 6 more similar to this one, so I'm hoping just for one macro rather than multiple ones. The second cell would search for a cell Value = ("*CAT II*") and will have a height adjusted to 58,5. This process hopefully can repeat itself for the other five cells.