I'd like to have a macro that would look in column AOT (beginning at row 5), and for whatever cell in this column is blank, the ranges of AJI:AOJ and AOO:AOS for that particular row would have their contents cleared.

For example, if AOT5 is blank, then AJI5:AOJ5 and AOO5:AOS5 would have their contents cleared. And this would happen down to row 500.

Any help would be greatly appreciated!