View Single Post
 
Old 06-21-2022, 05:42 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,505
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote