title: How to find the cell next to active cell in excel
body: <p>I want to create a log file in excel.</p>
  
  <p>I have created a macro that will insert in-time into active cell on ButtonInTime click. Similarly out time in the active cell on ButtonOutTime click... </p>
  
  <p>Now i want to insert todays date on <strong>ButtonInTime click in previous cell of active cell</strong></p>
  
  <p>and 
  <strong>calculate Total Log hours &amp; insert it into next active cell of OutTime</strong>.</p>
  
  <p>How i can achive this?
  Can any one help me out???</p>
  
  <p>I tried to find out the solution, but didnt get the proper one...</p>
  
  <p>Thanks in advance....</p>