vba if activecell range

  1. D

    VBA Help - If statement equal to a range of cells.

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

Some videos you may like

This Week's Hot Topics