Search found 1 match
- Mon Nov 28, 2016 5:31 pm
- Forum: Useful code, tips and tricks
- Topic: Clear TM1 Formulae from Excel
- Replies: 15
- Views: 47572
Re: Clear TM1 Formulae from Excel
Hi Jayme, This is what I have been using for years-looks to be a blend of Steve and Alan's approach. Sub Paste_TM1_As_Values() Dim cell Dim strFormula As String Dim bReplace As Boolean Application.ScreenUpdating = False Application.EnableEvents = False ' Select all cells with formulas then replace ...