Range and Rows.Count syntax error

[kmakjop]

Hello, can someone help me correct this syntax error. I have tried a few different ways that I think should work along with trying to Google it, still errors.

Please Login or Register  to view this content.

[alansidman]

Data = Worksheets("LINE 11 TP").Range("A4", Cells(Rows.Count, "I").End(xlUp).Row)

[HSV]

If activesheet not sheets("Line 11 TP").

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.

[nimrod1313]

HSV .. Great Catch !
So many people miss that when they code ( myself included)

[kmakjop]

Thank you alansidman

[HSV]

I'm sorry, but I really can't approve of this.
That addition from @alansidman really doesn't help you.

[kmakjop]

I just got a chance to test the code you sent alansidman, but it doesnt work. Thank you for the effort though, probably you overlooked something.

[kmakjop]

Thank you @HSV, your code worked perfectly.