If activecell.column = variable then activecell,offset (0,1)
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 |
If activecell.column = variable then activecell,offset (0,1)
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 |
All times are GMT +1. The time now is 01:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com