Thanks Hilmar
that was v helpful.
Nick
There was an interesting piece about Bolivia on the Radio the other day.
http://news.bbc.co.uk/1/hi/programmes/from_our_own_correspondent/4864464.stmI was interested in the Ayllu economy.
Nick
>>Hi
>>
>>I want to select a range of cells like
>>
>>oexcel.ActiveSheet.Range("A19:Q25").Select
>>
>>but I want to use cell number like r1c1 etc .
>>
>>Whats the syntax for that as I can't seem to get it right.
>>
>>Thanks
>>
>>Nick Mason
>
>You usually don't need to select the range of cells, you can work directly on a range of cells without selecting it.
>
>If loSheet contains a reference to an active sheet:
>
>
>loSheet.Range(loSheet.Cells(1, 1), loSheet.Cells(5, 10)).Font.Bold = .T.
>
>* or, using the WITH command:
>
>with loSheet
> .Range(.Cells(1, 1), .Cells(5, 10)).Font.Bold = .T.
>endwith
>