Formatting outline of cells

I have the following code to copy and paste from one workbook/sheet to another. Once i paste the value to the sheet i want to "underline" the entire row .......... any ideas?

Please Login or Register  to view this content.

Hi, Perhaps something like this:-

Please Login or Register  to view this content.

Regards Mick

something like this is exactly what i am looking for

BUT

This code gives me an error.............

I took the previous posters suggestion and this is what i came up with

Please Login or Register  to view this content.

Is this the best way?

Apparently the code i thought worked..........DOES NOT.

It works as long as the sheet is selected that i want to underline a row in. If a different sheet is selected prior to using the code then the ".select" has n error.

can any one help?

Here is the fix i found.........i think this works:

Please Login or Register  to view this content.