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

try ActiveCell.Column

RADO


"Christian Davidsson" <christian[DOT]davidsson[AT]skanemejerier[DOT]se
wrote in message ...
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

Hi Rado,

ActiveCell.Column gives me the value of the ActiveCell contents. I need the
actual column count (col A = 1, B = 2, C = 3, D = 4 ... Z = 24 etc. etc.)
based on the amount of columns to the left of the currnet cell.

Ragards,
Christian Davidsson


"RADO" skrev i meddelandet
...
try ActiveCell.Column

RADO


"Christian Davidsson" <christian[DOT]davidsson[AT]skanemejerier[DOT]se
wrote in message ...
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

Never mind my other post - I wrote ActiveCell.Columns (with an S on the end)
which caused it to return the value of the cell.

Thanks you very much for your help! It works just like it was supposed to
do.


Best regards,
Christian Davidsson

"RADO" skrev i meddelandet
...
try ActiveCell.Column

RADO


"Christian Davidsson" <christian[DOT]davidsson[AT]skanemejerier[DOT]se
wrote in message ...
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