+ Reply to Thread
Results 1 to 4 of 4

How to select multiple columns

  1. #1
    Registered User
    Join Date
    03-12-2008
    Posts
    76

    How to select multiple columns

    I am using VBA to change the format of columns. The code work with 1 column, but In need to change the format of mulitiple columns. E.g Cols 11 to 22. I tried the code below but it does not work!

    Please Login or Register  to view this content.
    This code works
    Please Login or Register  to view this content.
    but is only for one column!

    Thanks,

    Dave32
    Last edited by shg; 10-02-2008 at 11:41 AM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-12-2008
    Posts
    76

    How to select multiple columns

    Thanks SHG, you beat me to it, I also just managed to find the answer by trail and error.
    Please Login or Register  to view this content.
    Last edited by Dave32; 09-15-2008 at 04:24 PM. Reason: Got name wrong

  4. #4
    Registered User
    Join Date
    03-12-2008
    Posts
    76

    Site Admin

    Sorry, I cannot see the Edit Go Advanced button/menu. Please explain step by step from Login (dummies guide!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sumif or Sumproduct with Multiple Rows & Columns
    By vulches in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-12-2017, 02:06 AM
  2. Convert Multiple Columns to Single Row?
    By AboveBeyond in forum Excel General
    Replies: 4
    Last Post: 08-27-2012, 05:07 PM
  3. copying multiple columns into one long column
    By panproblems in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2008, 05:20 PM
  4. Select Multiple Criteria via Data Validation
    By jcavigli in forum Excel General
    Replies: 2
    Last Post: 06-10-2008, 02:57 PM
  5. SUM array with multiple columns
    By carsto in forum Excel General
    Replies: 1
    Last Post: 10-31-2006, 03:13 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1