Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ActiveCell or ActiveSheet | Excel Worksheet Functions | |||
ActiveCell in a Range? | Excel Discussion (Misc queries) | |||
highlight activecell | Excel Discussion (Misc queries) | |||
Activecell problem | Excel Discussion (Misc queries) | |||
Sum Activecell Offset Problem | Excel Worksheet Functions |