>>>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....

Thanks for the info, John. I'll hit your site later to-day.

As to the macro, yes, I am aware of that. There are reasons (which I'm going to mention in a post to Cetin) why it may not be the best way to approach the problem.

Thanks again,