Copying multiple ranges to a new sheet sequentially

  • Hi,


    I am trying to find a way to copy cell ranges 2 - 12 and 14 - 17 to another sheet. I can't seem to work out how to copy range 14 - 17 successfully.


    The code below manages to copy range 2 - 12 and cell 14 only.



    Any assistance would be greatly appreciated.


    Thank you

  • Re: Copying multiple ranges to a new sheet sequentially


    You don't actually extend the second range to cover columns 14-17 - you just mention 14.


    Also, you need to explicitly define each 'range'


    Code
    Union(Range(Cells(i, 2), Cells(i, 12)), Range(Cells(i, 14), Cells(i, 17)))...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!