I have been having some trouble using Application.ThisCell and need some help. To explain the issue, I created some simple code.
There are two workbooks. In each one, I have the following UDF in a module.
Function CalcIt(ByVal x As Variant)
CalcIt = Application.ThisCell.Column &...