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...