>Maybe, another question is how do you establish the last cell of the last row in the ActiveSheet so that I can create a range from A2 to the last cell of the last row.

Check out the UsedRange property of Worksheet. It references a range that contains only the part of the sheet that's in use.

Tamar