Thanks, Peter. I get error 450 when the range is a merged cell, but it works fine when it's a single cell. The cell/s have range names that define a single cell. If I define the range name as the merged cells, the code works fine for .Style, but then has other problems (such as assigning .Value). I'm a little stumped...