Excel sorting-issue with variable?

[Joe Glines]

I have a script which first identifies the column of interest and then sorts on it. When I put in the column to sort on as a number (in below case it is 6) my sort works fine. When I manually define my variable to =6 (Sort_Col_NB:=6), it works fine.
When I use a reference from the following function, it does not work (even though when I check the variable value it shows 6 and when I look at the variable type, it is an integer with no decimal places)
XL_String_To_Number("F")
XL_String_To_Number(Column){
StringUpper, Column, Column
Index := 0
Loop, Parse, Column ;loop for each character
{ascii := asc(A_LoopField)
if (ascii >= 65 && ascii <= 90)
index := index * 26 + ascii - 65 + 1 ;Base = 26 (26 letters)
else { return
} }
return, index
}

Code: Select all

xls.Range("A2:" . LastCol_Alpha . LastRow).Sort(xls.Columns(6),1) ;this works
xls.Range("A2:" . LastCol_Alpha . LastRow).Sort(xls.Columns(Sort_Col_NB),1) ;this does not

The initial error I get in Excel is saying "Specifically: Columns". If I continue running the script it then says there is an issue with "Sort"

Anybody have any ideas on what I'm doing wrong?

[toralf]

Just a guess but have tried to add % signs around the var?
Since you didn't provided the full ahk code for the Com or Vba commands it might be that the var name gets passed instead of the value. Or maybe ahk doesn't evaluate the var correctly because of the object.style.code.

Just brain dumps

[Hamlet]

[EDIT]
It feels so uneasy.
I deleted all the comment I wrote.

I do not know the reason clearly, but I could say like this;
The questioner answered selectively.
(S)He considered my answer as a garbage.
At the same time, I felt, was dumped into the garbage can.

I will nerver participate in this kind of dirty game. Promise. For ever.
It sucks.

[flyingDman]

Change the last line if your function to:

Code: Select all

return % index * 1

or, better, dump the function and use:

Code: Select all

col := xl.range("f:f").column

[Joe Glines]

I didn't post the rest of my script because it is really long and I didn't want to make anyone "dig" for finding my issue. I've used the variable references without wrapping it with % signs in the rest of the script with no issues.

flyingDman- per your suggestion I changed it to:

Code: Select all

xls.Range("A2:" . LastCol_Alpha . LastRow).Sort(xls.Columns(Source_Col . ":"Source_Col . ),1) ;sort sheet by interest

and it works great! Thank you for the help!