Can one define a range Name (using Insert > Name > Define) where height of range (i.e., # of rows) is defined by a variable whose value changes in VBA code?
For example, this range my_rng is defined as:
=offset(Sheet1!A1,0,0,xrows,1)

where xrows is a public variable whose value changes frequently.

Of course, the way the name is defined above mandates that xrows is another range already defined in workbook, which is something I am trying to avoid.
Thank you.

Alseikhan