title: Excel VBA code to move a sheet to the right or left by one
body: <p>I have a workbook with any number of worksheet tabs. I want to make command buttons to &quot;Move Left&quot; and &quot;Move Right&quot; which would move the worksheet within the workbook to the left or right (ie, to the left of worksheet to its left or to the right of the worksheet to it's right). Is there an easy way to do this? It seems with ActiveSheet.Move you have to know the name of the sheet to move it before or after. I don't know how to get the name of the sheet to its immediate right or left.</p>