N nd09 New member Aug 6, 2019 #1 Hello, I’m trying to compile a code and I get the attached message. this is the lines of code: Code: Set S = Application.ThisWorkbook.ActiveSheet S.ListObjects(1).Resize S.Range(S.Cells(1, 1), S.Cells(30, 16)) Need help as soon as posible Thank you.
Hello, I’m trying to compile a code and I get the attached message. this is the lines of code: Code: Set S = Application.ThisWorkbook.ActiveSheet S.ListObjects(1).Resize S.Range(S.Cells(1, 1), S.Cells(30, 16)) Need help as soon as posible Thank you.
gdgsupport Support Staff member Aug 13, 2019 #2 Try to add ( and ) Code: S.ListObjects(1).Resize( S.Range(S.Cells(1, 1), S.Cells(30, 16)) )