Hello, is it possible to set a range variable to a range that is typed into a cell? For example:
Cell A1's value = $B$1:$H$32
The above code doesn't work, hence why I am asking. Am I setting it up wrong? Or is this not possible?
I originally had rng setup to be something the user selects, but I'm trying to make it something the user only has to select 1 time, rather than every time this particular code is ran. This code automatically runs if it sees a change in specific cells.
VBA Code:
Dim rng As Range
Set rng = Sheet1.Cells(1,1).Value
Cell A1's value = $B$1:$H$32
The above code doesn't work, hence why I am asking. Am I setting it up wrong? Or is this not possible?
I originally had rng setup to be something the user selects, but I'm trying to make it something the user only has to select 1 time, rather than every time this particular code is ran. This code automatically runs if it sees a change in specific cells.