Hej! Hope that all is good with you.
I would like to adjust columns' widths based on if a cell is empty or not. Basically, if C2 is empty, then the column C width should automatically become 6 px. If any cell in row 2 is empty, those columns corresponding to those cells (D2 -> D, F2->F) should become 6px. However, the data is changing quickly, meaning that after I refresh the data, the columns can change and then they should all become the standard width of 25px unless these cells in row 2 are empty.
Any suggestion on how to solve this would be very helpful
ps: this same question is also posted here: https://www.mrexcel.com/board/thread...cells.1125032/
Thank you!
Vasco
Bookmarks