hide unsequential columns in vba

[BongoBill]

Hi all,

I'm using Excel 2003 and want to hide columns D:E & I:J. I have script as follows which hides I:J but I am unsure how to get it to include the other 2 columns. Grateful for any advice.

Please Login or Register  to view this content.

[Andy Pope]

use range instead.

Please Login or Register  to view this content.

[BongoBill]

Thanks Andy, but it then shows a bug on the following line: .Hidden = TRUE

Please Login or Register  to view this content.

[Andy Pope]

Add the EntireColumn reference

Please Login or Register  to view this content.

[BongoBill]

Many thanks Andy, works a treat now