I have the following function in Excel that returns the column number of a table based on the column header.
The table is called Config and the table column header is value. The below will return to me the column number in excel.

```
=COLUMN(Config[Value])-COLUMN(Config)+1

```

Could anybody let me know how this can be used in VBA?
I was hoping i could use something like ...

```
Application.WorksheetFunction.Column

```

but it seems `Column` is not available for me to use.

Would anyone have any ideas on this?
Any help would be greatly appreciated.