Copying Range gives object defined run wrror
That helped somewhat but I still could not get it to work.
I have this working but it pastes the formats.
How can I use this and only paste the values?
Range(Me.Cells(R, 6), Me.Cells(R, 42)).Copy Worksheets("Sample
Log").Cells(samplerow, 9)
|