The following code is skipping over merged cells.
Set RngNex = RngTar.Find("*", After:=RngCur, LookIn:=xlFormulas, _
LookAt:=xlWhole, SearchDirection:=xlPrevious, SearchOrder:=xlByRows)
I want to find non-blank cells in both merged and non-merged cells.
Why is this not working?
Is it a bug in Excel?
How do I fix it?