define range using sheets

[kato01]

Hello

I am trying to define a range using the sheets assignment like below

Public Sub TEST()
sh = Sheet1.Cells(4, 3).Value
Set rngChart = Sheets(sh).Range(Cells(8, 1), Cells(209, 44))
End Sub

I get an error. what am I missing?

Thanks

 

[JoeMo]

What's in Sheet1.Cells(4, 3)?

 

[MARK858]

Cross-posted here