Selecting multiple columns for reformatting

[yunesm]

I need a quicker and more efficient way of reformatting date columns. I put together the following code but it only allows me to specify a single column or continuous range.

I would like to be able to quickly identify multiple columns that need to be reformatted.

I would like to be able to input the column letters (a,b,d,e,f ect…) and have each of the respective columns selected for reformatting.

Any ideas on how do to this would be greatly appreciated.
Thanks!

Please Login or Register  to view this content.

[blane245]

Why not use cell selection as a means to generalize this? For example,

Please Login or Register  to view this content.

Then you just select the cells you want to format and run the macro. Assign it to a quick key to make it even faster.

[TMS]

Use Application.InputBox (as opposed to just InputBox) with type=8

Please Login or Register  to view this content.

You can select more than one area or several non-contiguous columns ... whatever

[yunesm]

Thank you both! These are both great. I'm tried them both and I'm going to see which one is most efficient.

Thanks again!

[TMS]

You're welcome. Thanks for the feedback.