VBA - How to "X" If "Y" is "This many" Characters long

Hi all,

Long time fan, first time post. I'm a [BIG emphasis] complete beginner [/BIG emphasis] to VBA so I'd like to apologize in advanced for my ignorance. I hope this is a very simply issue. It is probaby out there in the interwebs, but I just haven't been able to find an answer... then again, I don't know exactly what I'm looking for, or how to phrase it.

I'm (probably recreating the wheel) trying to set up code to format mailing/property address information. But I'm having difficulties with the ZIP code portion. This is what I have so far:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

This is more or less what I'm trying to do:

Please Login or Register  to view this content.

I'm basically trying to run the Step2 Macro only when the transposed cell values are 5 numbers.

Hopefully this makes sense! Again, I want to apologize for my ignorance.

Thanks,

-H-

Thank you ~tiger,

Sorry for the late reply. It took me a bit to figure out how to work out the code. But it was what I needed to get everything working. Here is what I ended up with:

Please Login or Register  to view this content.

Thank you again for the great help!

I do have one more quesion, however. I noticed this works perfecty, except when the value leads with zero's, i.e. "00001". Do you have any suggestions?

Also, can excel even read "00001" as numeric while retaining its leading zeros?

Thanks again!

-H-

Thank you ~tiger,

You were a great help with the very little to none information I provided! You answered my question (or lack thereof) perfectly.

I still have someproblems between figuring out how to differentiate between unit #'s, but I believe that will be a question for a next post, once I figure what it is that I'm really trying to do.

Thanks for your help!!!

-H-