You will notice I added the . (period) before the Range property as you use the With command.

Without the period the range would reference the active sheet rather than the sheet specified in the With