Hi all,

When I try to execute the following line of code...

Sheets("Jnl").Range("B3,I3,C41,H41,C7:H38").ClearContents
I get an runtime error message "Cannot change part of a merged cell"

Anyone know how to get round this??

Thanks