Macro ?

M

MR3

Board Regular
Joined
Jun 10, 2008
Messages
175
I wrote a macro that extracts data and puts it into 2 colums A & B of a Sheet in a workbook.

My question is how can I make that data become "Center Aligned" for all contents in Coloumn A & B all the way to the bottom of the Worksheet.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
Code: 
Sheets("Sheet name").range("A:B").HorizontalAlignment = xlhaligncenter
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Button to Clear contents from drop down select in Excel
Replies
3
Views
231
6StringJazzer
6StringJazzer
E
  • Question
Combining named worksheets with Macro
Replies
4
Views
496
Exl_in_Training
E
A
  • Question
Show Data Validation Lists in Next Row of Table
Replies
0
Views
435
AndyPandy27
A
K0st4din
  • Solved
How do I automate macros to be placed in many workbooks that won't be on my PC
2 3 4
Replies
33
Views
643
K0st4din
K0st4din
F
  • Question
Filtering/Copying a table via VBA.
Replies
2
Views
114
frobeniusabnorm
F

Forum statistics

Threads
1,214,936
Messages
6,122,340
Members
449,079
Latest member
rocketslinger

Share this page

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
Back
Top