this code not working

[bhandari]

iam in learning stage can anyone help me out y this code not working

Sub notworking()


ThisWorkbook.Worksheets(1).Range("A1:B10").cells (9)
End Sub

 

[Scott T]

What are you trying to do?

Cells is used to return a range.
This is A1 (cells(Row num,Column num)

Cells(1,1)

 

[bhandari]

Sub notworking()


ThisWorkbook.Worksheets(1).cells(9, 9) = 9
End Sub

iam looking for this,i got it

 

[Scott T]

Something like this will work.

Sub shouldwork()Worksheets("Sheet1").Activate
Worksheets("Sheet1").Rows(9).Select


End Sub

 

[MARK858]

Sub notworking()


ThisWorkbook.Worksheets(1).cells(9, 9) = 9
End Sub

iam looking for this,i got it

So you actually want cell I9 ? I never would have guessed that from post number 1.