Using Relative Addresses to Select Columns

[Andrew Rallings]

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

 

[keepitcool]

Andrew,

try:

columns("Q").resize(, 6).Select
or
columns(17).resize(, 6).Select

HTH


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >