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
