View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default 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