Cell Format Maintenance via Macro

[ctasich]

Hey guys,

I have a column that I often paste information to from a source with the following formats:

Align Text Right
Bottom Align

However, I would like this information to always paste with:

Center
Middle Align

Would it be possible to make a macro that automatically intercepts these copy/pastes formats and changes them to Center/Middle Align?

I need this to occur for all information in Columns B through H and J.

Thanks,
Chris

[Jbm444]

Just record a macro from the "view" section on the righthand of the ribbon. It should look something like this:

Please Login or Register  to view this content.

*You seem to want to make it automatic... To my knowledge though, you have to run any and all macros manually, so it wouldn't be faster than selecting the columns and doing it yourself. I don't think you can append a code to a worksheet that runs without any prompting from you. Unless you want to use a macro to do something else at the same time (i.e. copy/paste your data), a macro can be useful. Otherwise, I'm not sure a macro will accomplish what you want it to in this case.