I want to to select the next 5 columns after the current cell. the next 5
columns will change week by week.

Absolute cell references work say

Columns("Q:U").Select

What I can't find a way to do is use relative addresses eg

Columns("C[1]:C[6]").Select

I tried variations on the syntax but all without success. All get various
syntax or type mismatch errors

Any ideas?

regards
Andrew