Copy row of active cell to another sheet

Hello everyone
I'm trying to copy range("A:F") of the active cell row in Data sheet to Result sheet in the last row
I don't want to use copy method ..
I tried the following method but no results .. I mean no data copied to Result sheet

Please Login or Register  to view this content.

Any idea about that ..
It works with one cell ...Am I oliged to loop through columns of the active cell
For I = 1 to 6
.......
Next I

This worked

Please Login or Register  to view this content.

But I'm searching for method avoiding copy method and avoiding loop method

Thanks for help
I tried to add Value and it worked well

Please Login or Register  to view this content.