Con someone kindly tell me how to modify the line of code below so that
instead of copying the contents, formatting, validation, etc. of a cell, it
simply copies the cell's value?

Worksheets(Sheet1Name).Cells(Sheet1EmpTypeRowPoint er, h). _
Copy Worksheets(Sheet2Name).Cells(Sheet2RowPointer, _
Sheet2EmpTypeColPointer)

Thanks in advance for the help.