Moving a Range

[costadina]

Is there a way to write VBA code that can reference a range of data that may be moved on the spreadsheet by the User?

For example, if I write VBA code to reference a range of data such as:

Please Login or Register  to view this content.

then I can't "move" the range in the spreadsheet and expect the code to work. How can I code the range of data in VBA, so I am able to move it around and its location tracked by VBA? Is it possible?

[JBeaucaire]

Highlight the cells in their current location on the sheet and give the range a Name. Click in the NameBox (just to the left of the formula bar) and type in something like:
MovingRange

Now that those cells as a group have a name, VBA can use it, too.

Please Login or Register  to view this content.

[costadina]

Thanks a bunch