I have a Macro that has the following line it it. I also have a Range Name named CustomerData that is composed of A7:B50.
Macro line of code:
ActiveSheet.Range("$A$7:$B$50").AutoFilter field:=1, Criteria1:=Left(regionArray(iNextReg), 2)
For this line of code, I'd like to make it so that if I change the size of the range (i.e. by adding another line or two), that the Macro performs against the range and not the A7:B50. How do I code that?