>One last thing before I leave my friend.
>Doesn't directly :
>oRange = oWorkbook.ActiveSheet.Range(lcRange) work ?
I hadn't tried that yet. Remember, I'm coming from 1-2-3, so this is all new to me. If you say it does, then it must< g >. Actually, I simply recalled that there were multiple parameters (top left and bottom right) mentioned. Didn't read too closely, but I'm sure that you're correct here. < vbg >
>And if that cell operation is one of the things that excel could do in a snap (like all value = "somevalue", fill series, fill months, set formula etc) these are valid too :
>oRange.AutoFill(...)
>oRange.Value = "somevalue"
>oRange.Formula = "=$A$1*5"
Fortunately, I don't have to worry about that for now.:-)
George
Ubi caritas et amor, deus ibi est