I did try the solution that you proposed. however it leads to a circular reference error....does that mean i have to specify the exact row/columns in the range?