Define range and then unmerge/edit range

Hi all,

I'm not sure how to write the syntax for a little bit of code i am trying to complete.

Im not sure how to name a range that is ("A7:N"&lastrow),
and then go through that range and:
-unmerge all cells within the range
-Look in column C and if it is blank then clear the column N value in the same row.
-look in column A and if it is blank delete the entire row.

I already have the variable lastrow defined so no need to define it in your replies

Thanks for your help I've been trying to get this part for a while.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Regards, TMS

OK, try this, all the requirements in one subroutine.

Please Login or Register  to view this content.

Regards, TMS

You're welcome. Thanks for the rep.