On the wksheet "Criteria" I have two cells each containing formulas which return a string of text that acts as a range reference, as follows:
Cell M4 returns the following... Criteria!$J$8:$V$38
Cell M42 returns the following... Criteria!$J$47:$V$54
The two above ranges in this example are variable and will change so the vba needs to reference whatever is returned in the two cells M4 and M42.
I'm looking for some vba that will select both ranges at the same time and copy them ready for pasting as a union (as if you did it manually - ie. M42's range sits directly below M4's range).
Any help much appreciated.
Cell M4 returns the following... Criteria!$J$8:$V$38
Cell M42 returns the following... Criteria!$J$47:$V$54
The two above ranges in this example are variable and will change so the vba needs to reference whatever is returned in the two cells M4 and M42.
I'm looking for some vba that will select both ranges at the same time and copy them ready for pasting as a union (as if you did it manually - ie. M42's range sits directly below M4's range).
Any help much appreciated.