I'm very new to VB coding and I need some help on doing a function. I'm trying to copy a column and paste its "special formats" to another column in excel. It can't be in VBA, it has to be VB. Could someone please paste some sample code that I could copy? Thanks.

What do you mean that it cannot be in VBA but has to be in VB?
Why this constraint? (I ask because there might be a middle ground, and knowing the details would be helpful.)