Could someone tell me why that when I try to copy the value of a cell from one sheet to another, the macro runs fine, but nothing gets copied? The source range contains a formula, but I just want the values copied over.
Another problem I have: , for example, I'm trying to copy the range A1:C1 on sheet1 to D4:F4 on sheet2 and it says that the cells aren't the same size. Does the column width have to be the same size? I'm coping from a range of 3 cells to another range of 3 cells but I don't get it.
This message was edited by boydr on 2002-04-28 18:07
Another problem I have: , for example, I'm trying to copy the range A1:C1 on sheet1 to D4:F4 on sheet2 and it says that the cells aren't the same size. Does the column width have to be the same size? I'm coping from a range of 3 cells to another range of 3 cells but I don't get it.
This message was edited by boydr on 2002-04-28 18:07