View Full Version : Solved: Set Value of Merged And Centered Cells

08-19-2008, 12:39 PM
I've got a range of cells (A1:M1) that have been merged and centered. I need to use VBA to place some text into this range of merged cells, but I'm not sure how to refer to it.

Do I reference the whole range, or just one of the cells in the merged range to set the text into it?

Bob Phillips
08-19-2008, 02:24 PM
Just refer to the first cell in the mergearea.

08-20-2008, 01:55 PM
That got it working perfectly- thanks.