>>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.:-)
OK :) Wellcome to "hair pullers club" :)
As John said recording a macro is a good way of "stealing" how to. It's not as straight forward all the time but 99% works. Just be carefull what an object "applies too". For a quick starter :
Range("B5:Z10")
Range("B5:G10,A6:Z7,1:1,M:M")
are valid ranges :) Try this :
ox=createobject("Excel.Application")
with ox
.Workbooks.Add
with .ActiveWorkBook.ActiveSheet
.Range("B5:G10,A6:Z7,1:1,M:M").Select
endwith
.Visible = .t.
endwith
If you plan cells carefully you can "sign" with selection :)
Cetin