I entered a line of code that seemed to me it should work, since the cue
that appears when you enter a range using "Cells" says that "Cell2" is
optional (in brackets), but it's not.

This should be, if the cue were correct, an acceptable line of code:

Set rClient = wsTribalHist.Range(Cells(3, lHistDataFinalCol + 1))

But isn't.
But this line is ok:

Set rClient = wsTribalHist.Range(Cells(3, lHistDataFinalCol + 1), Cells(3,
lHistDataFinalCol + 1))

So the cue indicates that the Cell2 after the comma is optional, when it is
really required.

What I'm wondering is are these false cues listed anywhere, or do we just
learn them as we go? I'm starting to make notes about these things because
I find it hard to remember all these little glitches. Has anyone attempted
to compile a list?