Assigning Style to ActiveCell which is part of Merged Cells
 

Hi all

- I have a named range that comprises several cells merged as one, eg A1:D1
- Consequently, if this cell is selected, ActiveCell.Address = "A1"
- When a user double-clicks this cell, I want to change the Style property of
the cell
- To do this, I need to apply the Style to A1:D1, and not just the ActiveCell
- Can anyone please suggest how I can capture the address of the merged cell,
given ActiveCell?

Thanks in advance

Paul Martin
Melbourne, Australia