Excel 2016 macro workbook.
I have a number of client lists based on the month they were activated. I need to create a named range for every month and want to minimise the number of time i spend to manually update the ranges.
I created the following to create the named range:
With...
Sometimes it is needed to make use of variable variables.
Lets say you want to build up a variable name by using another variable.
The first part of the variable is always the same (CMD in this case), but you have an incremental number behind it.
If we have:
# CMD1=one
# CMD2=two
#...