sheet name with cell string in vba

[BiKeTa]

i want to know how to use a string in VBA to find a worksheet based on the contents of a cell
i thought this would work but cant seemed to figure out what keeps throwng an error

Code:
Private Sub CommandButton1_Click()

Dim shtName As String
Dim rngAddress As String
shtName = Range("b5").Value
rngAddress = Range("c5").Value
Sheets(shtName).Range(rngAddress).Value = Range(b8).Value




End Sub

 

[Joe4]

You are missing the double-quotes around the B8, i.e.

[COLOR=#333333]Sheets(shtName).Range(rngAddress).Value = Range([/COLOR][COLOR=#ff0000][B]"[/B][/COLOR][COLOR=#333333]B8[/COLOR][COLOR=#ff0000][B]"[/B][/COLOR][COLOR=#333333]).Value[/COLOR]

 

[BiKeTa]

sweet lord. thank you i had banged my head against the keyboard all morning over this. works like a dream.