I have the following sub routine that is trying to copy a data cell from one worksheet to another…
Dim DataString As String
Application.ScreenUpdating = False
DataString = Worksheets("Data").Range("E2:E2").Value
Application.ScreenUpdating = True
When the statement below is executed…
This error occurs…
Run-time error '1004':
Select method of Range class failed.
I am trying to copy the data in cell E2 from the worksheet named “Data” to
Cell F5 in the worksheet named “DRA Summary”
Can anyone help with this or suggest a better way of accomplishing this data copy?