title: Reveal Column by clicking on the Cell in it
body: <p>I have a sub (on WorkSheet) which enlarge Column when I click on the Cell. The problem is I can't back original size of the column when I leaving it.</p>
  
  <p>I tried use some default parameters, but this end with error.</p>
  
  <pre><code>Then rngDEwidh.Columns.ColumnWidth = rngDEwidh.Columns.ColumnWidth
  Then rngDEwidh.Columns.ColumnWidth = xlNone
  Then rngDEwidh.Columns.ColumnWidth = ActiveCell.width
  </code></pre>
  
  <p>Here is a sub:</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  
      Static rngDEwidh As Range
      If Not rngDEwidh Is Nothing Then rngDEwidh.Columns.ColumnWidth = xlNone
      Set rngDEwidh = Target
      rngDEwidh.Columns.ColumnWidth = 25
  End Sub
  </code></pre>
  
  <p>Error when using xlNone and its ok if I use any value (10 for instance). But I need original size of the column.</p>