How do I select a range of columns using Union?

[c.davidson]

I have some code linked to a button when pressed to show and hide a range of columns. The Column range can change depending who needs to use what amount of columns.

To dictate the range, I have named the cell before the range "ColStart" and the cell after the range "ColEnd".

The code I have is shown below to hide and show the columns within the range, but it seems to only show the two named cells columns, how do I make it use the range in between the named cells?

Please Login or Register  to view this content.

I hope I've explained this well enough.

[xlnitwit]

Hi,

You need only use Range rather than Union

Please Login or Register  to view this content.

[c.davidson]

Hi,

You need only use Range rather than Union

Please Login or Register  to view this content.

Thankyou! Works perfectly now