I am trying to copy text from one sheet to another using the Cells
function.
Originally I tried .Value, but I think that only works for numbers,
not letters/words.

That being said, here is what I have below.


Sheets("Sheet1").Cells(ItemRow, ItemColumn).Select
Selection.Copy
Sheets("Sheet2").Cells(SokuteiItemRow, SokuteiItemColumn).Select
ActiveSheet.Paste

Yet when I run the program, I get a debugging error and the third row
of the above code is highlighted.

Where am I going wrong? Is there an easy way to do the code below
which works with numbers, with letters?

Sheets("Sheet2").Cells(SokuteiItemRow, SokuteiItemColumn).Value =
Sheets("Sheet1").Cells(ItemRow, ItemColumn).Value

Thanks. Neil