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?