xltoright

Ok I have a problem with xltoright ..


basically I have my macro look for a certain age that is found in a text box called "compage"

when it finds the age it offsets the cell down one

then I want to clear everything under it

so here is my code

Please Login or Register  to view this content.

the problem is there is "blank" cells or cells with a formula that = 0

I still want those to be deleted but it stops when it gets to them ,

how can I fix this

so for example lets say the age is found at 47

I want it to clear everything under it even if the cell = 0

Capture.jpg

thank you both for your replies , I had just come back to post that I had done this to solve

Please Login or Register  to view this content.