Thanks for your response Rowan. I reconfigured all Sets in the Select
Case but I still get an error messege: "Run-time error '91': Object
variable or With block variable not set." This happens at line
TableRange = Range("MM30YFTable"); this is if I choose my Case value to
select this range.