find columns

[CG Rosén]

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

 

[Don Guillett]

Close. Lose the s on columns

 

[Harald Staff]

Hi

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

c = ActiveCell.Column

 

[Tom Ogilvy]

c = ActiveCell.column


without the "s"