title: AutoHotKey Excel hotstring formulas using arrow keys to find cells for equation
body: <p>I'm trying to create a couple hotstrings using arrow keys to select cells for the formula that is created.</p>
  
  <pre><code>:*:=concacane::
  send =CONCATENATE({right},{right 2},{right 3})
  return
  </code></pre>
  
  <p>The above is the code that I was hoping would work to call the 'CONCATENATE' function and select the three cells to the right of the cell I was typing in. Unfortunately Excel seems to escape the cell I was working in, and I end up with commas and parenthesis spread across a few cells to the right instead of the working formula I was looking for.  </p>
  
  <p>I tried using 'sendraw' and adding everything after '=CONCATENATE(' on a second 'send' line hoping that the '=' was some kind of modifier that was messing me up, but that didn't seem to help. I also tried using a key combination instead of a hotstring but I couldn't get that script to do anything at all and a key combination would be less than ideal anyway...</p>
  
  <p>Does anybody have any idea how I can get this to work? Thanks in advance!</p>