How can i Paste the values in Selected Rows?

 

I am trying to implement VBA to copy one row of data and paste that data in selected rows.

My code is applicable to only one selected row, but I want more than one selected rows.

my code is:Private Sub CommandButton1_Click()


 ThisWorkbook.Sheets(“Sheet1”).Range(“A$3:J3”).Copy Destination:=Selection


End Sub

 

 

By: Ajay

2 thoughts on “How can i Paste the values in Selected Rows?

  1. ig

    What’s Going down i am new to this, I stumbled upon this I have discovered It positively helpful and it has aided me out
    loads. I am hoping to give a contribution & aid different customers
    like its aided me. Good job.

Comments are closed.