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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top