Is it possible to set a cell range based on an inputbox?
As an example I have an inputbox, and based on the users response I would like to set a particular range that can be used throughout my code.
In my mind it would be something like
Select Case strArea
Case 80
x="E12"
Case 82
x="E13"
Case 84
x="E17"
From there I can use Range(x) and based on the above Range("E12") would be used if 80 was entered.
Am I out of my mind?
Thank you
As an example I have an inputbox, and based on the users response I would like to set a particular range that can be used throughout my code.
In my mind it would be something like
Select Case strArea
Case 80
x="E12"
Case 82
x="E13"
Case 84
x="E17"
From there I can use Range(x) and based on the above Range("E12") would be used if 80 was entered.
Am I out of my mind?
Thank you