Search:
Type: Posts; User: mernst
Search:
Search took 0.02 seconds.
-
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...
-
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...
-
On:
sheets("source").range(sheets("porder").cells(i, 1).value).copy sheets("destination").cells(j, 1)
-
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?
-
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...
-
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...
|
Click Here to Expand Forum to Full Width
|