Solved: Set Value of Merged And Centered Cells [Archive]

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

CreganTur

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.

CreganTur

08-20-2008, 01:55 PM

That got it working perfectly- thanks.