Hi All
No doubt the solution is quick, but here goes....
I want to select 2 non-contiguous cells within a macro.
If I specify….
Range("D5,M16").Select
…that works.
If I use the same logic and use the following code (for different cells) then it does not work.
ACA1 = ActiveCell.Address...