how to select a variable row depending on a number i introduce

hi!
i want to introduce a number in the textbox1, and that number sets which entire row to select for making a chart. i thought of something like this, but i cant put the variable x just like that. please help!

Private Sub CommandButton1_Click()
Dim x As String

If TextBox1.Text <> "" Then
x = TextBox1.Text
Range("Ax:Mx").EntireRow.Select
ActiveSheet.Shapes.AddChart.Select
ActiveChart.SetSourceData Source:=Range("'sheet1'!$A$x:$M$x")
ActiveChart.ChartType = xlLineStacked
UserForm1.Hide
End If

End Sub

Try this.

Please Login or Register  to view this content.

PS Please edit your post to use code tags.

thanks! i just register so i didnt know about the tags, next time.

i try doing it with 2 textbox now, but y throws me an error

Please Login or Register  to view this content.

Can you edit and add the tags?

Makes it a lot easier to read the code.

All you need to do is select the code and click the # on the toolbar.

Thanks for adding the tags.

The problem is the ; separating the range references here.

Please Login or Register  to view this content.

Replace the ; with a , and the code should work.

Please Login or Register  to view this content.

It works fine for me on a worksheet which is blank, apart from data.

Can you post a sample workbook?

I've tried the uploaded workbook and can't reproduce the error.

What did you put in the textboxes when the code errors?

That's exactly what I did and the code worked.

I even tried entering rows that were blank and all it did was produce a blank chart.

Is there anything else going on in the workbook or on the worksheet?