Hi Scott,

Try one cell at a time...

Sheet1.Range("LName").Value = "Anderson" makes all 3 cells = "Anderson"

To check...

MsgBox Sheet1.Range("LName").Cells(1,1).Value will return "Anderson"
as will Sheet1.Range("LName").Cells(2,1).Value and
Sheet1.Range("LName").Cells(3,1).Value

Ken Johnson