danjames11
New Member
- Joined
- Apr 22, 2009
- Messages
- 14
I have a range of cells going from B13 all the way to B400. I know how to write this:
If ActiveCell = Range ("B13,B14,B15,B16,B18,and so on") Then....
But I want to be able to do something like B13:B14 instead of writing all the way to 400, But B13:B400 does not work.
Anyone know how to do this.. Once again, I want to see if the active cell is equal to any of the cells in the the range B13 To B400.
Thanks.
If ActiveCell = Range ("B13,B14,B15,B16,B18,and so on") Then....
But I want to be able to do something like B13:B14 instead of writing all the way to 400, But B13:B400 does not work.
Anyone know how to do this.. Once again, I want to see if the active cell is equal to any of the cells in the the range B13 To B400.
Thanks.