I created the node group that the node “Sprites Animation” is based on. It’s not based on the old way to animate sprites from before BGE/UPBGE .3, as I never used/tried the old way, so you have to figure out a different way to use the node so that it can fit your needs.
As for animating with keyframes:
ex. If you were to keyframe tile 1 at frame zero in the timeline and at frame sixty you keyframe tile 24 it will also go through the tiles in between those two. To prevent that from happening you could go to the graph editor, select the keyframes, right-click, interpolation mode and then select constant.
If you are using logic bricks, are you using Loop Stop (or End)?
Could you elaborate or show a screenshot of the issue.
If you would like to double check to see if you set the node up properly you can go the following topic to view an explanation as to how the Sprites Animation node should be set up.