LastRow VBA Error

[animas]

I was using

    Dim LastRow As Long
    LastRow = Worksheets(Sheet1).Cells(Rows.Count, 0).End(xlUp).Row

But it is showing me error. How to solve this?


Thanks.

 

[VoG]

Try

LastRow = Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row

 

[animas]

I need to use excel sheet name(Sheet1) rather than user edited names that uses "". How do I use that here?

 

[=ODIN=]

LastRow = sheet1.Cells(Rows.Count, [B][COLOR=red]1[/COLOR][/B]).End(xlUp).Row