View Single Post
  #2   Report Post  
Stefi
 
Posts: n/a
Default 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