CellsSRC - visXFormHeight .. .what am I doing wrong?

[Mac]

When a shape is 16 mm in height, how do I check this property? Using this:

If grpShp.CellsSRC(visSectionObject, visRowXFormOut,
visXFormHeight).FormulaU = "16 mm" Then

does not work, anyway the code seems stupid to me...looks like I'm setting
here instead of retreiving ( can't hide I code in C ).

 

[John Goldsmith]

Hello Mac,

If you're retrieving a value then you need to use the Result property
instead of Formula. So your If statement should look like this:

If grpShp.CellsSRC(visSectionObject, visRowXFormOut, _
visXFormHeight).Result(visMillimeters) = 16 Then

Best regards

John


John Goldsmith
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk

 

[David Parker]

Have you tried:
If grpShp.CellsSRC(visSectionObject, visRowXFormOut,
visXFormHeight).ResultStr("mm") = "16.0000 mm" Then