Excel 2007 macro to merge cells

[DougP]

I want to highlight a few cells and merge them
I recorded this macro which has cell selection embedded in it.
How to I change it so that it takes the cells I currently have highlighted and merges them

    Range("J8:K8").Select   ' change this to my selection
    With Selection
        .HorizontalAlignment = xlGeneral
        .VerticalAlignment = xlBottom
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = True
    End With

TIA


DougP
< I Built one

http://www.robots2000.com

 

[DougP]

wow I stumbled on this mby accident
I just removed the reference and it works

    With Selection
        .HorizontalAlignment = xlGeneral
        .VerticalAlignment = xlBottom
        .WrapText = False
        .Orientation = 0
        .AddIndent = False
        .IndentLevel = 0
        .ShrinkToFit = False
        .ReadingOrder = xlContext
        .MergeCells = True
    End With
[code]

so "With Selection" knows what I have highlighted 


DougP
[r2d2] < I Built one
[URL unfurl="true"]www.robots2000.com[/URL]

 

[SkipVought]

Doug,

You've been around long enough to know that VBA questions are best addressed in forum707 AND that we discourage such postings in this forum.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}