Excel+ VBA – Selecting a range

How do i refer to a range of cells (row..or column)whose location on the screen (row) and size, varies depending on other variables.

i wish to use this range within a sub procedure….but i always need to refer to that specific data…