New to Macros, having issue with print macro

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

You need the ' character at the start of the NumberFormat specification, otherwise Excel will "helpfully" convert the string value with leading zeros to a numeric value without leading zeroes.


Hope this helps - please let me know how you get on.

Regards,

Greg M

I Greg,

Thanks for the help, your code is certainly much more concise. It didn't fix the issue, but it helped me figure it out. The A6 was not located on the same worksheet as "Traveler", so it make A6 = 1, print. Active worksheet would then move to the printed sheet, and it would alter a cell I didn't want it to. As of now, all is working.

-Ransom

Hi again,

Many thanks for your feedback.

You're welcome - glad I was able to help.

Regards,

Greg M