If/else/loop troubles

[yee0890]

Hi all, I'm new to AHK, and have been browsing and searching this past day to find a solution to my problem. What I'm trying to achieve is simple: if an Excel cell value is 2, move down. If value is not 2, write 2, move down. Repeat these steps 10 times, and spit out a message "end of loop". What am I doing wrong?

Code: Select all

#s:: 
xl := ComObjActive("Excel.Application")
cellvalue :=xl.activecell.value
loop, 10
{
if (cellvalue = 2)
{
Sleep, 500
Send, {Enter}
Sleep, 500
}
else
{
Send, 2
Sleep, 500
Send, {Enter}
}
}
msgbox, end of loop
Return

[Spark]

maybe something like this?

Code: Select all

#s::
	xl := ComObjActive("Excel.Application")
	loop, 10
	{
		cellvalue :=xl.activecell.value
		if (cellvalue = 2)
			xl.ActiveCell.Offset(1,0).Select ; Move Down
		else
		{
			xl.activecell.value := 2	; Change number "2"
			xl.ActiveCell.Offset(1,0).Select	; Move Down
		}
	}
	msgbox, end of loop
return

reff :
Excel Tutorials and XL Function library
Basic Ahk_L COM Tutorial for Excel
HTH