How to find nth column

[dhatul]

In my VBA code I want to find out nth column from the column I am am currently working on.

Let us say my source data is in Column 'P'. Based on this I want to read data from say next column (+1) or from 3rd column (+3).
Issue is how do I get the reference of the next column or third column from column 'P'. The reference has to be alphabetic i.e. column 'Q' or 'S' and not numeric.

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[TMS]

I have to ask ... why do you "need" the column letter as opposed to the column number?

[dhatul]

I have to ask ... why do you "need" the column letter as opposed to the column number?

Will Columns() and Range() work with column numbers? If so can you show me the syntax?

[TMS]

Seeing as I have no idea what it is you are trying to achieve, here are some examples:

Please Login or Register  to view this content.

Regards, TMS