> > [code]
> > from pythoncom import Missing
> > usedRange = xlApp.ActiveSheet.UsedRange
> > usedRange.Find('FXN3', Missing, constants.xlValues,
> > constants.xlWhole, constants,xlByColumns,
> > constants.xlNext, False, False, Missing)
> > [/code]
>
> Whoa -- disregard that suggestion; that was really bad idea on my
> part. All the arguments after the first Missing get ignored if
> you do that.
pythoncom.Empty will behave as you desire - it will present an "empty"
variant (VT_EMPTY). There is no way to truly provide NULL for an individual
item as they are passed as an array (and pythoncom.Missing is where this
array gets terminated)
It might actually be useful to print a warning (via the warnings module) if
any params are supplied after a missing, as the user probably doesn't intend
for them to be ignored. As usual, patches welcome :)
Mark
_______________________________________________
Python-win32 mailing list
Python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
