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 Westi 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
How can I set the allignment property for some cells via vb.
I would want to do something like
excelapp.activesheet.range("g1:i1").alignment = center

mim
 
Sort by date Sort by votes
just do:

excelapp.ActiveSheet.Range("G1:I1").HorizontalAlignment = xlCenter

If you want can also use the VerticalAlignment property to align the cell contents vertically.

This should work for ya
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

marty1944
  • Locked
  • Question
error code 380 when trying to run the visual basic v6 deployment wizard
Replies
1
Views
682
marty1944
marty1944
VisKataboman
  • Locked
  • Question
Linear Column Gauge measurement form on Visual Basic 6.0
Replies
1
Views
293
xwb
xwb
sacsac
  • Question
Commas in CSV fle
Replies
8
Views
285
gmmastros
gmmastros
Swi
  • Locked
  • Question
Parsing Names in multiple formats
Replies
5
Views
399
SaltyTheFrog
SaltyTheFrog
sal21
  • Locked
  • Question
scraping table in web page 3
2
Replies
24
Views
3K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top