Hi all, i would like to know how to delete entire column including the header if the cells until last row column is empty. In this attached book 1, i have mention number on the header example; 2504, 2505, 2506, 2507 & 2508. I would like to delete entire rows including number 2505, 2507 and 2508 due to there is no data until the end of the last row columns. Thanks in advance ;-)