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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
RoryA

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
40,427
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
Code: 
Sheets("Sheet name").range("A:B").HorizontalAlignment = xlhaligncenter
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Question
INDEX MATCH HELP
Replies
0
Views
55
newbieDB
N
O
  • Solved
Automating Reports - Pasting Tables into Email
Replies
2
Views
190
oddzac
O
C
  • Question
Copy entire row to another worksheet
Replies
5
Views
232
Skyybot
Skyybot
N
  • Question
VBA CODE COLOR
Replies
1
Views
86
mohadin
M
O
  • Question
VBA Extracting Data from multiple workbooks, with varying sheet names
Replies
4
Views
207
HaHoBe
HaHoBe

Forum statistics

Threads
1,191,575
Messages
5,987,385
Members
440,094
Latest member
leeuniverse

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
Top