Account numbers cannot start with zero without first converting those cells to text....which goes against the idea of an account "number", eh?

Convert your account numbers to actual numbers, then use cell formatting to "display" leading zeros if you really feel you need to see them. Then the macro should work fine as designed.