Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste value error
I have written a program that needs to copy and paste row by row to
another page in an excel spread sheet but some of the rows have merged cells and when it comes to paste a row with merged cell it comes up with a error. I can not paste all as I need the formula values only due to hidden rows between the pasted rows of infomation. Is there any way to fix this |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste value error
you have to copy to the cell(S)
range("a2:b2").copy range("d22:e22") or if values only range("d22:e22").value=range("a2:b2").value -- Don Guillett SalesAid Software "PJG" wrote in message ps.com... I have written a program that needs to copy and paste row by row to another page in an excel spread sheet but some of the rows have merged cells and when it comes to paste a row with merged cell it comes up with a error. I can not paste all as I need the formula values only due to hidden rows between the pasted rows of infomation. Is there any way to fix this |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shortcut for paste special? | Excel Discussion (Misc queries) | |||
"unable to paste link" Excel error message | Excel Discussion (Misc queries) | |||
Error Handler Not Working | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) | |||
excel - numbers as text | New Users to Excel |