Is it possible to define a particular range of cells so that you can just refer to the range name in the code? This is what I tried, however it didn't work. Also, if I can do this, when I use it in the code would I just put " selectrng.value = "" "if I want it to clear out all of the values in the range? Thanks. I tried it with parentheses and without and it still wouldn't work.


Dim selectrng as Range "D10:D15,F10:F15,H10:H15"