PDA

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?

xld
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.