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