"A4" is a string containing A4. So it's looking for a sheet called "A4".If you want to pass the value of A4, then it's A4.Value (no quotes).