Assigning values to variables

[dpaton05]

I have some code where I assign values to variables:

    'assign values to variables
    Combo = Worksheets("Home").Range("Y5")
    LastRow = Worksheets(Combo).Cells(Rows.Count, "A").End(xlUp).Row + 1                                    'number of first empty row in column A of Combo
    TableNumberRows = Worksheets("home").ListObjects("tblCosting").Rows(Rows.Count).Row                       'specific row in tblCosting
    tblRows = ListObjects("tblCosting").ListRows                                                            'number of rows in tblCosting

What is wrong with the syntax of the last 2 lines?

Thanks

 

[MARK858]

Depends what your objective is as you haven't stated it so we can't tell you the correct syntax without guessing.