PDA

View Full Version : Solved: Exclude rows



av8tordude
04-07-2009, 01:36 PM
I inputed this code to exclude certain columns, but I realized that I need to exclude rows 1-8. Can someone help me accomplish this task. thank you in advance.


Select Case Target.Column
Case 1 To 4, 14, 15, 19 To 21, 28 To 47
Exit Sub
End Select

Bob Phillips
04-07-2009, 02:05 PM
With Target

Select Case True
Case .Row < 8
Exit Sub
Case .Column < 5
Exit Sub
Case .Column >= 13 And .Column < 16
Exit Sub
Case .Column >= 19 And .Column < 22
Exit Sub
Case .Column >= 28 And .Column < 48
Exit Sub
End Select
End With

av8tordude
04-07-2009, 02:37 PM
Thank you xld :)