Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro stopped working after upgrade to 2007
Hi,
the following macro stpped working after upgrade to Office 2007. I used it to get the actual formula as text. Help is much appreciated. Cheers, Harold Function GetFormula(Rng As Range) Dim myFormula As String GetFormula = "" With Rng.Cells(1) If .HasFormula Then If Application.ReferenceStyle = xlA1 Then myFormula = .Formula Else myFormula = .FormulaR1C1 End If If .HasArray Then GetFormula = "{=" & Mid(myFormula, 2, Len(myFormula)) & "}" Else GetFormula = myFormula End If End If End With End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Networkdays Stopped Working - Again | Excel Worksheet Functions | |||
2007 Upgrade wont run macro | Excel Discussion (Misc queries) | |||
Why have my Excel Macro Shortcuts stopped working? | Excel Worksheet Functions | |||
VB Stopped Working | Excel Worksheet Functions | |||
excel stopped working | Excel Discussion (Misc queries) |