I have a range whose address is something like this: $A$25:$D$26,$A$43:$D$47

I need to extract the values from col A and col C and ignore the values from the col B and D.

I am really stuck with this problem and can somebody provide me a VBA code to do that.

Thanks in advance.