I need help with a macro

Posted by Mark A. Lowe on January 08, 2002 1:43 PM

I need a macro that will copy the contents of a cell into the cell on another sheet. I will run this macro several times, so the contents will need to be sent to the next available cell. Any ideas?? Thanks, Mark

Posted by Jacob on January 08, 2002 1:51 PM

Try This
Dim MyValue
MyValue = Sheets("Sheet1").Range("A1").value

Sheets("Sheet2").range("A65536").end(xlup).offset(1,0).value = MyValue

HTH

Jacob

Posted by Mark A. Lowe on January 08, 2002 2:06 PM

Thanks Jacob, worked perfectly!!