Define range and then unmerge/edit range

[bruizer31]

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.