Search:

Type: Posts; User: mernst

Search: Search took 0.02 seconds.

  1. Re: [Excel]: How to reorder ranges in predefined order.

    Hi Pete,
    I am sorry for the very belated reply. As you pointed out, the error in the first method was caused by my not specifying named ranges on the source sheet. After I did so, it worked...
  2. Re: [Excel]: How to reorder ranges in predefined order.

    It seems to happen on the first row, as the error report stops the procedure immediately after it begins running. I checked the porder sheet and there are no empty rows between cells. Thanks a lot...
  3. Re: [Excel]: How to reorder ranges in predefined order.

    On:
    sheets("source").range(sheets("porder").cells(i, 1).value).copy sheets("destination").cells(j, 1)
  4. Re: [Excel]: How to reorder ranges in predefined order.

    Thanks Pete,
    I tried testing the code with some names from the pre-defined order in a "porder" sheet. But, I keep getting "Run-time error 1004". Is there something I'm doing wrong, you think?
  5. Re: [Excel]: How to reorder ranges in predefined order.

    Many thanks for your reply!
    I realise I didn't provide a good explanation to my problem. I am attaching a workbook with some extracts from the main (source) sheet. The predefined order would be the...
  6. [RESOLVED] [Excel]: How to reorder ranges in predefined order.

    Hi,
    I need some VBA help in copying ranges from one sheet to another and pasting them on a predifined order. I have one worksheet that contains a large number of ranges with data on alphabetical...
Results 1 to 6 of 6



Click Here to Expand Forum to Full Width