i recently asked the same question in another post, and i assume you mean, is there a way to refer to a cell range in a macro so that if the location of that cell range changes, the reference to it in your code also changes automatically. as far as i know, the only way to do this would be to name your cell range in your sheet, then in your macro, use your range name instead of the cell reference to refer to you range.
HTH
kevin