In your code the word sample is placed in the active sheet.

To place the word sample in a specafic sheet use

Sheets("sheet1").range("d2").value = "sample"

or

workSheets("sheet1").range("d2").value = "sample"

You can also specify a workbook by

workbook("book1").Sheets("sheet1").range("d2").val ue = "sample

--
mudrake
-----------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...nfo&userid=247
View this thread: http://www.excelforum.com/showthread.php?threadid=26945