I am trying to copy named Excel ranges from one worksheet and paste them on another worksheet.
The pasted ranges have to appear contiguously one below the other. I surmise that for this I have to be able to move the active cell of the destination worksheet to the row after the last-pasted range, then do the next paste. But try as I might, I cannot find a way to do this. A function giving the height of a range in cells would be ideal, but I can only find one that gives the height in points. No use.
Learned experts, I appeal to thee for help.
Thanks in advance