Hello, little correction in VBA

[Meko1]

Hello
Please help me out in this small matter.
My code is following:

ActiveSheet.Range("B6") = Sheet10.Range.Text("B2") & (" C2")

So I want from sheet10 to get B2 and C2 cell data in my active sheet B6 cell. But as it seems Right side of the code leaks something.
Since B2 and C2 are name and surname I want them to be like text, Lets say B2-John, C2-Smith and B6 to read John Smith.

Thanks in advance

 

[My Aswer Is This]

When you say My code.
I assume you want a Vba solution


Try this:

Sub My_Script()
'Modified 12/6/2020  5:39:45 AM  EST
ActiveSheet.Range("B6").Value = Sheets(10).Range("B2") & " " & Sheets(10).Range(" C2")
End Sub

 

[Meko1]

Thank a lot

 

[My Aswer Is This]

Thank a lot

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

 

[My Aswer Is This]

I would guess you may want more then this:
If you want help making this script do more let me know
Like maybe you want this to keep going down from B6 to B7 and B8 and more

 

[Meko1]

I would guess you may want more then this:
If you want help making this script do more let me know
Like maybe you want this to keep going down from B6 to B7 and B8 and more

Thank you, I am new to the VBA, coding and I am learning it step by step, trying different options... If I have other difficulties I would let you know for sure.