I'm trying to use Application.Caller to alter the background of the cell that called the function, however it always returns an invalid value. However, I'm hardly a VBA expert, so I might be doing this entirely wrong.
What I do later isn't really relevant since it fails on this block. If I try to debug, Caller has an "error 2023" value.
Dim R as Range R = Application.Caller