View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Emece Emece is offline
external usenet poster
 
Posts: 82
Default Need to obtain Col Letter - VBA

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.-