Posts by kpxl60

    Hi All,


    I have read that using .select & .activate, are bad practice and slow down the code. I am copy and pasting between sheets and am finding it is taking quite a long time to execute.


    Would anyone be kind enough to tell me how I would clean up the following code? Or is this one those occasions when those two actions need to be used?


    Thanks!!


    Hi,


    Really need some help with the following task please.


    I need a macro to copy and paste every 2nd cell in specific columns (they differ) to another sheet but in consecutive rows. I need for instance to copy and paste everything that has a value, starting from cell G9 and continuing with G11, G13... and start copying into another sheet from B3, B4, B5.... I also need in the same macro to copy and paste the cells from G10, G12, G14... into the other sheet into DX3, DX4, DX5..... I would usually have between 5 and 25 cells to copy.


    If anyone could explain how to do this it would be much appreciated!
    Thanks!