Thanks very much. It seems to be working great now. Good catch on the L6:O3 it was actually supposed to be L6:O6.
Yes you are correct on just the 3 columns clearing and not the entire row.
This has been a hurdle for m.e It's great to be moving on to new ones.