F
Fergus
Hello,
I have a macro that copies a named range from one workbook to another.
The line of code is:
DestinationWorkbook.Range(rname).Value = OriginalWorkbook.Range
(rname).Value
This works great, but sometimes my named range in the destination
workbook is larger than the original. In this case the range in the
destination workbook is returning #N/A for all of the extra cell
addresses that are not in the original named range. I would like to
return a blank instead of #N/A if the the address in the destination
workbook doesn't exist in the original.
Hope this makes sense. I apologize if it's been addressed. I didn't
see it.
I have a macro that copies a named range from one workbook to another.
The line of code is:
DestinationWorkbook.Range(rname).Value = OriginalWorkbook.Range
(rname).Value
This works great, but sometimes my named range in the destination
workbook is larger than the original. In this case the range in the
destination workbook is returning #N/A for all of the extra cell
addresses that are not in the original named range. I would like to
return a blank instead of #N/A if the the address in the destination
workbook doesn't exist in the original.
Hope this makes sense. I apologize if it's been addressed. I didn't
see it.