Forum Discussion
Range.SpillParent
Quick question. The VBA Range/Cell object has a .SpillParent property which allows one to find back to the top left corner (TLC) of a Spill from any cell within the Spill. That is, I can point the ...
Patrick2788 I admire the effort but that isn't a viable solution. I take the silence on the forum to mean that there is no standard facility to find to the TLC.
PS: your char+64 will fail starting from column AA 😉
Indeed, that's what I meant when I mentioned the limitations of CHAR.
If only AREAS was more robust . .