Thread: How to find the begining col number of adjacent area

I have a sheet that has some data in the first part of it. The amount of cols is variable in this first part. There is an "empty" col of data and then the next area of data begins.

My question is how to find the col number of this adjacent area.

I am enclosing a file. In the file the adjacent area starts at col "I". But again this is variable as the first area may ahve varying number of cols.

Hi

If a VBA solutions is acceptable it would be something like

Sub Findcol()
Dim c As Long
MsgBox "Column number is " & Range("A1").CurrentRegion.Columns.Count + 2

End Sub