I need to select a range of rows in some data which can be variable.

How do you write in a macro to select say rows 1 to N, where the N is
dependent on other factors in the macro.

possible sublimely simple?!