Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel in visual basic

Status
Not open for further replies.
VBmim

VBmim

Programmer
Jun 25, 2001
361
BE
I want to set the alignment of some cells to Center from Visual basic.

I want to do something like this

excelObj.activesheet.range("g1:i1").alignment = Center

Does something like that works?

Mim
 
Sort by date Sort by votes
Yes, this is a very basic funtionality. This will do the trick for you:
ActiveSheet.Range("g1:i1").HorizontalAlignment = xlCenter

Steve
 
Upvote 0 Downvote
Instead of .alignment=center you should use
.HorizontalAlignment = xlCenter

gmonk
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

office365
  • Locked
  • Question
app visual basic excel
Replies
4
Views
164
office365
office365
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
573
remeng
remeng
sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
204
sal21
sal21
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
338
huiettcm
huiettcm
f0rg3tfu1
  • Locked
  • Question
VBA Error in Excel
Replies
11
Views
330
combo
combo

Part and Inventory Search

Sponsor

Back
Top