Cappy [Wink]

xlWhole is 1

Best trick here is to use ObjectBrowser in Excel VBEditor ... it gives you all the enumerated constants and their assoc. hex values.