Hi Catalin,
Thanks for your suggestion. I've tried it but it does not seem to work. Perhaps it's because some of my columns have word wrap turned on.
I've tried to reproduce the problem in a simpler worksheet. I created three cells. Each of them have different heights due to the different lengths of information in the cell with word wrap turned on.
The macro reduces the height of cell A3 from 28 to 15, while the other 2 cells' height remain the same.
I've uploaded the sample workbook.
I'm trying to increase the "top and bottom" spacing between the cells by a fixed amount.
|