VBA syntax for scaling a trend

Discussion created by cjrancur on Mar 11, 2011
Latest reply on Mar 16, 2011 by Ahmad Fattahi

I found that I can scale a trend using either of these commands within a "with myTrend" block:


.SetTraceScale "Autorange", "Autorange"




Call .SetTraceScale("Autorange","Autorange")


What is the difference between a space followed by parameters, and  parameters within parentheses?  Is one syntax version better than the other for ProcBook use?


I tried to use a VT_Variant instead of the string, "Autorange", but VT_Variant was not available.  Which reference should be added to enable VT_Variant objects?


Also, I tried using the second statement, where the parameters were within parenthesis, but without the leading Call statement, and it did not work.  I don't understand why. For example, there is a difference between the two statements below. The first works and the second doesn't. Why?


Call .SetTraceScale("Autorange","Autorange")