In statements like this:
dim ws as worksheet
ws = ThisWorkbook.worksheets(1)
ws .Rows([range of rows]).AutoFit
Set myRange = ws .Rows([range of rows]).EntireRow
how might I specify the [range of rows] using just numbers, instead of the string "R1C4" type construct?
That is, something like this:
which executes, but then this:
fails with "Select method of range failed", so I can't verify if I really have the range of rows I want in r1.
Any suggestions on this would be appreciated.