find columns
 

Good Evening,

Thanks for the help to find the row number by code.

Tried: c = ActiveCell.Columns

This seems to always be the value 0, when this is the
the cell from where all is relative. Is there a way to find the
columns absolute number ( A = 1 etc).

Thanks for help.

Brgds

CG Rosén

find columns
 

Close. Lose the s on columns

"CG Rosén" wrote in message
...
Good Evening,

Thanks for the help to find the row number by code.

Tried: c = ActiveCell.Columns

This seems to always be the value 0, when this is the
the cell from where all is relative. Is there a way to find the
columns absolute number ( A = 1 etc).

Thanks for help.

Brgds

CG Rosén

find columns
 

Hi

You're sooo close. It's Column and not Columns :

c = ActiveCell.Column

--
HTH. Best wishes Harald
Followup to newsgroup only please

"CG Rosén" skrev i melding
...
Good Evening,

Thanks for the help to find the row number by code.

Tried: c = ActiveCell.Columns

This seems to always be the value 0, when this is the
the cell from where all is relative. Is there a way to find the
columns absolute number ( A = 1 etc).

Thanks for help.

Brgds

CG Rosén

find columns
 

c = ActiveCell.column


without the "s"

--
Regards,
Tom Ogilvy

CG Rosén wrote in message
...
Good Evening,

Thanks for the help to find the row number by code.

Tried: c = ActiveCell.Columns

This seems to always be the value 0, when this is the
the cell from where all is relative. Is there a way to find the
columns absolute number ( A = 1 etc).

Thanks for help.

Brgds

CG Rosén