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. Jul 27th, 2007, 09:56 PM #1
    DougStroud
    DougStroud is offline
    Board Regular
    Join Date
    Aug 2005
    Posts
    2,864

    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
    Reply With Quote Reply With Quote
  2. Jul 27th, 2007, 09:59 PM #2
    ExcelChampion
    ExcelChampion is offline
    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.
    Todd
    www.ExcelChampion.com
    Reply With Quote Reply With Quote
  3. Jul 27th, 2007, 10:00 PM #3
    DougStroud
    DougStroud is offline
    Board Regular
    Join Date
    Aug 2005
    Posts
    2,864

    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!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules


DMCA.com