select first cell in unmerged range

[Jack Sons]

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

 

[Guest]

Simply
ActiveCell.Select

Regards,
Stefi


„Jack Sons†ezt írta:

 

[Jack Sons]

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

Jack.