Paste value error

  • Thread starter Thread starter PJG
  • Start date Start date
P

PJG

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy paste data from a column to a row 0
Pasting into a filtered sheet 3
Copy and pasting values of filtered rows 1
VALUE err calculating indirect number 5
MACRO PASTE CELL to COLUMN, SKIP ROWS 1
copy formulas over merged cells 2
"Last cell" in Excel 2003 is way past end of data, how do i fix? 11
copy/paste row with one formula 6

Back
Top