select first cell in unmerged range
 

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

select first cell in unmerged range
 

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

select first cell in unmerged range
 

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