title: Find out the last used column in a given row - Excel VBA
body: <p><img src="https://i.stack.imgur.com/9bhyB.jpg" alt="Say I have the following values in my excel"></p>
  
  <p>I have to get the last used cell in a particular row.</p>
  
  <p>For example: If I choose A1 the last used column should return 3.</p>
  
  <p>Row/LastUsedColumn
  A1/     3
  A2 /    4
  A3 /    3
  A4 /    3
  A5 /    1
  A6  /   3
  A7   /  4</p>