Before Close Trim Code

[Dazzawm]

Is it possible to add a before close code that runs some of trim that will look at column AE and remove any spaces that may be at the end of any data in a cell?

 

[saboh12617]

Hello,
You could add something like this in your workbook.close event.
Be careful that it will erase the formulas if present, and replace them with the cell values instead.

Sub xyz()
  Range("AE:AE").Value2 = Evaluate("TRIM(AE:AE)")
End Sub

 

[Dazzawm]

Hello,
You could add something like this in your workbook.close event.
Be careful that it will erase the formulas if present, and replace them with the cell values instead.

Sub xyz()
  Range("AE:AE").Value2 = Evaluate("TRIM(AE:AE)")
End Sub

Thanks chief.

 

[saboh12617]

Glad to help