E
Elton Law
Dear Expert,
I am writing a marco but get stuck in one part.
Address A1 to C2 is defined the name as AAA
Address D1 to F2 is defined the name as BBB
Address G1 to I2 is defined the names as CCC
Address J1 to L2 is defined the name as DDD
.......
Say Cell A5 has an answer "1". Then the marco will automatically select AAA
(A1 to C2).
Say Cell A5 has an answer of "2". Then the marco will select BBB (D1 to F2).
Etc Etc ..
A5 is a formula and the answer can be 1 to 12 .....
Then help me to select each range depending on the answer in cell A5.
Is that feasbile?
I am writing a marco but get stuck in one part.
Address A1 to C2 is defined the name as AAA
Address D1 to F2 is defined the name as BBB
Address G1 to I2 is defined the names as CCC
Address J1 to L2 is defined the name as DDD
.......
Say Cell A5 has an answer "1". Then the marco will automatically select AAA
(A1 to C2).
Say Cell A5 has an answer of "2". Then the marco will select BBB (D1 to F2).
Etc Etc ..
A5 is a formula and the answer can be 1 to 12 .....
Then help me to select each range depending on the answer in cell A5.
Is that feasbile?