Formatting Macro

02ajs

New Member
Joined
Jan 24, 2005
Messages
3
New user to Macro's. I have a download into excel and I want it to format to the way that I like it automatically (ie. move copumn c to comlumn A, Center column C, insert columns at certain widths, etc.). Is that possible to do using a macro and if so, could you recommend a book/site or whatever to find out how to do it?

Thanks
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

clipro

Board Regular
Joined
Jan 12, 2005
Messages
195
Do You want just to format like:

1. I want to move column A before column F
2. To change Font in cells A10:C53 to Arial Bold
3. To put borders etc.

If the macro must do only this so click Tools > Macro > Record new macro and give a name to your macro

execute all steps (like move, formatting etc.) and press stop button (the new toolbar)

after, when you want to start the macro just choose tools > Macro and choose your macro
 

Glaswegian

Well-known Member
Joined
Oct 14, 2003
Messages
1,487
Welcome to the Board!

One of the best ways is to record a macro while doing your formatting. You might want to test on a copy first. Click on Tools | Macro | Record New Macro - then give your macro a name and also specify where you want to store it. Then, as you do your formatting, Excel will record all your actions. Click on 'Stop' when you are finished. You can run your macro by pressing Alt+F8 and then select your macro from the list. To view the code created, press Alt+F11 and look for the workbook name in the left pane. Expand the list and look for Module 1 - double click to view the code.

There is a search facility on this site as well as an online store and plenty of Excel sites on the net.

HTH

Regards
 

02ajs

New Member
Joined
Jan 24, 2005
Messages
3
Man, this is great!....thanks for the help. I'll give it a shot and see what happens.
 

Forum statistics

Threads
1,147,508
Messages
5,741,568
Members
423,667
Latest member
Kai_357

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top