VBA Programming a Macro (involving merging cells in Excel 2007)

[SarahB2]

Hi,
I'm wondering if there's a way to program a macro, so that when the cells are merged and when it runs, it doesn't prompt the user to acknowledge that the cells are merging, and that it just runs automatically? Here's some code I'm using to give a better idea.

Range("A2:B2").Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = True
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = False
End With
Selection.Merge

I've also tried making a small edit like this:

Range("A2:B2").Select
With Selection
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlBottom
.WrapText = True
.Orientation = 0
.AddIndent = False
.IndentLevel = 0
.ShrinkToFit = False
.ReadingOrder = xlContext
.MergeCells = True
End With

but the result is that the user is still prompted to acknowledge the cell merge. Is there a way to avoid having the user respond and just run automatically? Thanks for your help!

[tom1977]

hi try this

Please Login or Register  to view this content.

[SarahB2]

Thanks for your help! It worked.