Forgot how to copy paste using vba coding.

[omairhe]

How do I copy one value of cell to the other along with mentioning the sheet name.

For instance the code below will copy just fine but I do also want to put my sheet name, although the copy and paste value resides on the same sheet.

Range("M6").Value = Range("M5").Value

suppose my worksheet name is "Hello world" for both the copied and pasted value.

Will appreciate and thanks.

 

[Fluff]

How about

With Sheets("Sheet1")
   .Range("M6").Value = .Range("M5").Value
End With

 

[omairhe]

How about

With Sheets("Sheet1")
   .Range("M6").Value = .Range("M5").Value
End With

Yes, thank you.

 

[Fluff]

You're welcome & thanks for the feedback.