>I tried that. I did an alt+tab to the spreadsheet from the debuger window and went back and I got 160 values from the activecolumn property and half of them were 0. Not sure how I could make that work.
>
>Thanks
I see. What about passing filed name as parameter?
dynamicforecolor = checkname(fieldname)
--sb--