Hello,

I'm sure this is pretty easy, but my brain has just locked down - and I
can't figure it out.

I need to find the column count based on ActiveCell. If ActiveCell is in the
D column, the result should be 4, coloumn C should be 3 etc.

I'm using this value in as a parameter for some calculations later on in the
code. Currently - I'm using "colCount = ActiveCell.Columns.Count" but this
only returns the value 1.

Any help would be appriciated.


Thanks in advance,
Christian Davidsson