I've been scrathching my head over this, but for the gurus, this is probably simple.

I've got a weekly file that I update. There are two summary columns that are all the way to the right of the Excel worksheet, and they are the last two columns that an Excel sheet can hold (Columns IU and IV, I believe) . I unhide all available data and hide any columns which have not yet populated data that are blank.
For example, this week I uploaded data into Column C. I need to have Columns D:IT hidden, and leave the last two summary Columns exposed.

I have not been succesful automating hiding and unhiding the columns, since every week the range of columns that I need to select to hide/unhide will change. Does any one have advice on how I should accomplish this?

If I haven't explained this well. let me know.
Thank you experts!