You are right, changing Sheet1 to ActiveSheet, or completly remove the "Sheet1" word (including the dot next to it) will do.