Determine Column Number in a function
Function ColNum() As Integer
ColNum = Application.Caller.Column
End Function
Just enter =ColNum() in a cell.
However, =COLUMN() does that already!
"cubbybear3" wrote in message
ups.com...
I have a function that needs to know the column number/letter of the
cell calling it. How does a novice like myself do this? Thanks. -
pb
|