Select Table Cells

S

S Shulman

Hi
I need to select in VBA a number of cells (for merging) in the same column
when I use the Move (with expand) it doesn't work properly for various
reasons
Is there any way to add to the Selection.Cells collection an existing cell
So I can merge them together

Thank you in advance,
Shmuel Shulman
 
G

Greg Maxey

Maybe something like:
Sub ScratchMacro()

With Selection
.Cells(1).Select
.MoveDown Unit:=wdLine, Count:=3, Extend:=wdExtend
.Cells.Merge
End With

End Sub
 
Top