Concatenate error

[rdev]

Hi, can a friend help with the concatenation , where am i wrong in the syntax?

finalrow = Sheets(2).Range("B" & Rows.Count).End(xlUp).Row
MsgBox finalrow
Sheets(2).Range("B6:B" & finalrow).Select

 

[VoG]

Try

finalrow = Sheets(2).Range("B" & Rows.Count).End(xlUp).Row
Application.Goto Sheets(2).Range("B6:B" & finalrow)

 

[RoryA]

If the second sheet is not the active one, you cannot select a range on it. you would have to select the sheet first, then select the range. Note, though, that it is almost never necessary to actually select sheets or ranges to work with them in code.