The code i have didn't give me any error, it just didn't work. By adding ListObject before Range gives me an Object Required error.