Hide blank columns via loop

Hi All,

I've written below codes for automatically hiding blank columns via loop in the each worksheet of the current workbook, but it's not running well...

Please Login or Register  to view this content.

Can anyone please help me and correct the codes??

what you mean blank column ?
you want to go through all cols and check if any data exists in current columns and if no data exist you want to hide this columns yea ?

above conditions are coded into example file, please check it - for now works only in activesheet after press command button "test"

Best Regards

Thanks for ur reply! ur codes are fine, but I hope you can understand what my below written codes say, and wht is my aim?

Please Login or Register  to view this content.

....above my codes are just working fine up-to a limit, it hides all the columns via a loop, ...but I want to hide every blank column from the column E to the last column.

P.S. ›—›› Is there any method to hide the entire column or row in a veryhidden mode, so no-one can't see wht columns/ rows are hidden???