fif_rumac
02-05-2007, 05:12 AM
Hello All,
Please forgive me if I am missing something really obvious here...
I have 2 WorkSheets on different WorkBooks. I have created code to copy a range (A1:C1) from Sheet1 and paste it to sheet2. The problem is that although the code seems to copy ok, when the paste code runs it does not paste over the values from the range. It pastes 0 in each cell.
Does someone know what the problem might be?
Thanks,
fif_rumac
Please forgive me if I am missing something really obvious here...
I have 2 WorkSheets on different WorkBooks. I have created code to copy a range (A1:C1) from Sheet1 and paste it to sheet2. The problem is that although the code seems to copy ok, when the paste code runs it does not paste over the values from the range. It pastes 0 in each cell.
Does someone know what the problem might be?
Thanks,
fif_rumac