dynamic range names

[Daves Drywall]

Trying to use a macro to copy a Dynamic Range to a closed Workbook, want to paste the value of the copied range to the end of the current list in the closed workbook... ive almost got it.. but can't seem to copy a dynamic range name.. i have to manually scroll over and pick up the range i want.. click on a hyperlink. Use end Down to get to bottom of list, Arrow Key one row down. copy paste values, then close workbook, to return to first workbook. Can VBA Copy a Dynamic range name without having to manually pick it up..

 

[GeorgeB]

I sent you an e-mail. Give me a call.