Select Case ActiveCell.Column
Case 2, 5, 8, 9: ActiveCell.Offset(0, 1).Select
End Select

"Battykoda via OfficeKB.com" <u33810@uwe wrote in message
news:7919cbcaf7db7@uwe...
Hi everybody.
I've been trying for the past few days to do that.

variable = 2, 5, 8, 9

If activecell.column = variable then
activecell.offset(0,1).select

For some reason, it does'nt skip the column like i would like to. I think
it's in the declaration of my variable.

Anyone have an idea??

Thanks!

Batty

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200710/1