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?

ColStart = Sheets("Sheet1").Range("ColStart").Column + 1
ColEnd = Sheets("Sheet1").Range("ColEnd").Column - 1

    Union(Columns(ColStart), Columns(ColEnd)).EntireColumn.Hidden = False
I hope I've explained this well enough.