>I am having issues with vartype() even though the field returns a null value Vartype wont acknowledge the "X" reference
I never used this with Automation - I don't really know.
You can check normal Visual FoxPro values for isnull(MyExpression). But again, I don't know how this would work with Excel Automation.
Note that in VFP, type() and vartype() are supposed to work differently here:
x = 5
x = NULL
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)