Originally Posted By: 1984
You are using variables which I cannot figure out what they really represent and do, and how you get their values
 Code:
$xlDown = -4121 
$xlToLeft = -4159 
$xlToRight = -4161 
$xlUp = -4162

Nothing to understand about, just take it because they are like that. In fact those numbers are constants. See the link in my first post.
Microsoft Excel Constants (Excel 2003 VBA Language Reference)