>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.
with loSheet
.Range(.Cells(1, 1), .Cells(5, 10)).Font.Bold = .T.
endwith
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)