select first cell in unmerged range

Jack Sons · Oct 20, 2005

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

Stefi · Oct 20, 2005

Simply
ActiveCell.Select

Regards,
Stefi

â€žJack Sonsâ€ ezt Ãrta:

Jack Sons · Oct 20, 2005

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

Jack.