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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
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
225
6StringJazzer
6StringJazzer
E
  • Question
Combining named worksheets with Macro
Replies
4
Views
487
Exl_in_Training
E
A
  • Question
Show Data Validation Lists in Next Row of Table
Replies
0
Views
394
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
588
K0st4din
K0st4din
G
  • Question
Macro Code Help for multiple worksheets.
Replies
1
Views
164
Georgiboy
Georgiboy

Forum statistics

Threads
1,214,517
Messages
6,119,984
Members
448,935
Latest member
ijat

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