9 Replies Latest reply on Jun 10, 2014 6:23 PM by samacnt

    Zoom-in Member with VBA

    5cc6afef-005d-4ebb-a898-1b67f6245153

      Hello-

       

      I'm attempting to zoom in on a single member in cell A2 using a VBA script. I know a little about VBA, or enough to be dangerous but am new to using HypZoomIn function. Below is script I've used from the how-to guide provided. However, I keep receiving the error  "Compiler Error: Expected =". Can  anyone please provide assitance as to where there is is coming from and the correction needed? Thank you!

       

       

      HypZoomIn(vtSheetName, vtSelection, vtLevel, vtAcross)
      ByVal vtSheetName As Variant
      ByVal vtSelection As Variant
      ByVal vtLevel As Variant
      ByVal vtAcross As Variant

       

      Sub ZoomData()
      x = HypZoomIn(Empty, Range("A2"), 2, False)
      If x = 0 Then
      MsgBox ("Zoom successful.")

      Else
      MsgBox ("Zoom failed.")
      End If
      End Sub