Steve;603938 Wrote:
Morning all.
I'm making a user form, and want to select a cell to place my equation,
then
with that selection choice, offset upwards, and to the side, to select
and
merge two sets of two cells, each.

I understand with my selection that I'd use the following:
activecell.offset(0,1).select
to get my first cell selection.
But how do I retain that initial selection, and then offset one more
up, to
then merge those two cells?

Thank you.

Set StartCell = Range("D4")
StartCell.offset(0,1).formula = "=Sum(A1:A5)"
StartCell.offset(0,1).resize(1,2).merge


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=167483

Microsoft Office Help