>>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.:-)
You might want to look at some of the sample OLE code on my website. Most of it was from Randy Brown (MS) and some I've modified. You are probably also aware you can just record a macro in Excel and go with that....
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright