MrExcel Publishing
Your One Stop for Excel Tips & Solutions

For using non-integers


Posted by sid on October 22, 2001 5:38 AM

Is it possible to loop through A,B,C,D,etc
I am trying to apply it as follows
If ' conditions specified
For 'This is where I am stuck
If positionvalue = A ' I wnat to loop this ie next is B,next C, etc.
Then 'copy/paste which i can loop
any help much appreciated
Sid


Posted by Juan Pablo on October 22, 2001 7:29 AM

Are you talking about Column headers ? if so, then you can use integers, Column A is 1, B is 2, etc. you can use either Cells(rownumber, colnumber) or Column(colnumber) to do whatever it is you're trying to do

Juan Pablo

Posted by sid on October 22, 2001 10:05 AM

No, it is a text value in a cell
sid

Posted by Juan Pablo on October 22, 2001 11:52 AM

How about using the Chr function ? Letters A - Z (Caps) are from 65 to 90, meaning:

Chr(65) will return "A"
Chr(66) "B"
...

Chr(90) "Z"

Juan Pablo

Posted by sid on October 22, 2001 11:59 AM

Cheers Juan,
will try & incorporate this