Select case target.address named range

  • Hi, I want to use select case with a named range. the code I'm using is:

    Now nothing happened, I prefer to not use the if form as usual. The ranges are composed of cells every three rows and every 7 columns, like A1 A8 A4 A8...

    thanks for you help! :)

  • Hello,
    or maybe something like,,,

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!