cjrancur

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"

 

or

 

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") 

 

and

 

.SetTraceScale("Autorange","Autorange") 

 

Carrie

Outcomes