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 Chriss Miller 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
Joined
Jun 25, 2001
Messages
361
Location
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 Question
app visual basic excel
Replies
4
Views
549
office365
office365
2009luca
  • Locked
  • Question Question
put value in input box web page
Replies
0
Views
393
2009luca
2009luca
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
2K
remeng
remeng
sal21
  • Locked
  • Question Question
scrping in listbox in a web page
Replies
0
Views
749
sal21
sal21
Andrzejek
  • Locked
  • Question Question
Hyperlinks in Word cut at #
Replies
2
Views
697
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top