Selecting a row to set row height in Excel

How do I select a row/rows in Excel to change the row height? Here is the results of an Excel macro that does this:

    Rows("1:1").RowHeight = 69

With my_sheet as my worksheet object, I tried:

my_range = my_sheet.Rows('1:1');

but this gives me the error:

??? Index exceeds matrix dimensions.

Answer 1

[Jiro Doke]

Try using the "Range" property.

my_range = my_sheet.Range('1:1');