Get Cell Data From A Worksheet, Place It In A Table

[JonesZoid]

All

I have a piece of code that creates a new row at the end of a table which i then reference as oNewRow.

I am now trying to get a specific cell from a another worksheet, and place it in a certain cell in the oNewRow.

Here is what i have tried thus far, to no avail

oNewRow.Range.Cells(1, 5).Value = wsqt.Range(Cells(Selection.Row, 2).Address).Value

wsqt has already been set to the relevant sheet.
When run, the hard coded values show in the table but not the values from another sheet.... CONFUSED....

Craig

 

[JonesZoid]

All

I have found a crude way of acheiving this now.
But if anyone can improve the code that would be much appreciated.

wsqt.Activate
wsqt.Range(Cells(Selection.Row, 2).Address).Copy
wspl.Activate
oNewRow.Range.Cells(1, 5).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False