Need to obtain Col Letter - VBA

[Emece]

Hi.

I have a macro, and I need to obtain the col letter and not the number, so
as to go to one column to another, adding 1. I entered the following code:

ActiveCell.Column = ActiveCell.Column + 1

But ActiveCell.Column returns the column number, which is the correct code?

Thanks in advance

Regards

Emece.-

 

[Don Guillett]

You can use the column number in CELLS
cells(2,activecell.column)
range(cells(2,activecell.column),cells(22,activecell.column))
where the first number is the row and the second the column