For current cell addresses, look in the 'Sticky' thread at the top of this forum...
Finding the adjacent cell(s) requires looping forward/backward, as appropriate.
With horizontally merged cells, there may be more than one cell above or below.
With vertically merged cells, you may have to loop through multiple rows to find all those adjacent or to find the one below.
And, where you're dealing with both, you might have to deal with horizontally-merged cells above/below/beside vertical ones.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|