I'm trying to write a macro to copy info from two cells and paste it into
another Sheet named ToDo transposed and in the first available cell in Col A.

The cells I want to copy are the equivalent of R2C and RC so if I'm in cell
D34 then I would get D2 and D34 copied into A1 and B1 on ToDo Sheet assuming
it was empty.

I'm fine with the pasting part of the macro but whatever I try to select and
copy the non contiguous cells returns an error so I would appreciate some
help with the coding to do this.

Many thanks