Hello.

Im using a sub that copies the sheet, then deletes blank rows. The only problem i have is... the Cell is often too small for the text. You can easily fix this manualy in Excel just by pressing the edge of sheet number twice, but i want it done automaticaly. Could you please help me?

PS. The width of cell remains the same, just the height needs the fix

problem.jpg