Skip to content

Instantly share code, notes, and snippets.

@miya2000

miya2000/test

Created April 15, 2014 23:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save miya2000/10786520 to your computer and use it in GitHub Desktop.
Save miya2000/10786520 to your computer and use it in GitHub Desktop.
Download ZIP
Excel2013: Odd FormulaR1C1 When Activating Graph sheet.
Raw
test
Sub Test()
Sheet1.Activate
ShowR1C1ToA1 ("=RC[-1]") ' [=A1]
Graph1.Activate
ShowR1C1ToA1 ("=RC[-1]") ' [=XFD1]
End Sub
Sub ShowR1C1ToA1(formulaR1C1 As String)
Sheet1.Range("B1").formulaR1C1 = formulaR1C1
MsgBox Sheet1.Range("B1").Formula
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment