Macaulay Culkin has landed his next big role as he continues to enjoy a career resurgence