Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying named range returns #N/A
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying named range returns #N/A
To do it this way the ranges must be the same size. Instead you could use copy/paste values -- Don Guillett Microsoft MVP Excel SalesAid Software "Fergus" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM() of empty dynamic named range returns #N/A | Excel Programming | |||
Pass named range to user defined function returns #value! | Excel Programming | |||
Pass named range to user defined function returns #value! | Excel Programming | |||
HLOOKUP using a named range returns #VALUE! | Excel Worksheet Functions | |||
Named range returns 1004 error | Excel Programming |