Hi all,

With

Selection.Unmerge

I unmerge a merged number of adjacent cells in a certain row. Now I want to
select the first (left most) cell of that range. What code does the trick?

Jack Sons
The Netherlands

Simply
ActiveCell.Select

Regards,
Stefi


€žJack Sons€� ezt Ã*rta:

Hi all,

With

Selection.Unmerge

I unmerge a merged number of adjacent cells in a certain row. Now I want to
select the first (left most) cell of that range. What code does the trick?

Jack Sons
The Netherlands

Thanks, I felt that I somehow was overlooking the obvious, now I'm sure.

Jack.

"Stefi" schreef in bericht
...
Simply
ActiveCell.Select

Regards,
Stefi


"Jack Sons" ezt írta:

Hi all,

With

Selection.Unmerge

I unmerge a merged number of adjacent cells in a certain row. Now I want
to
select the first (left most) cell of that range. What code does the
trick?

Jack Sons
The Netherlands