Search found 1 match

by sof4246
Mon Nov 28, 2016 5:31 pm
Forum: Useful code, tips and tricks
Topic: Clear TM1 Formulae from Excel
Replies: 15
Views: 45084

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 ...