Copy and Paste Row

[JPaulo]

Hi all;

I open Book2, I enter the user name and password and must make the copy and paste the whole line and not only found the cell.

See attc please

 

[Brianwarnock]

you want something like

ActiveCell.EntireRow.Copy

Brian

 

[JPaulo]

Hi, thanks for response.

Resolved:

Range(rCell.Offset(0, 5), rCell).Select

 

[Brianwarnock]

So you just wanted 5 columns, the selected one and 4 to the right , not the entire row, why didn't you say so.

Brian