Results 1 to 3 of 3

HorizontalAlignment = xlCenter ?

This is a discussion on HorizontalAlignment = xlCenter ? within the Excel Questions forums, part of the Question Forums category; Can this line be written as one? I have tried altering the syntax, but that is not the answer. Code: ...

  1. #1
    Board Regular
    Join Date
    Aug 2005
    Posts
    2,878

    Default HorizontalAlignment = xlCenter ?

    Can this line be written as one? I have tried altering the syntax, but that is not the answer.
    Code:
    Columns("M:P", "U:V").HorizontalAlignment = xlCenter
    Thanks,

    Doug

  2. #2
    Board Regular ExcelChampion's Avatar
    Join Date
    Aug 2005
    Location
    Detroit, MI
    Posts
    952

    Default

    Range("M:P,U:V").HorizontalAlignment = xlCenter

    FYI, I got this from the macro recorder. No matter how good you get, its still a good tool.

  3. #3
    Board Regular
    Join Date
    Aug 2005
    Posts
    2,878

    Default

    Thanks Todd

    my site: www.ecboardco.com
    was built w/ a tremendous amount of help and guidance from mrexcel and a few dedicated board members: A Huge Thanks!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com