+ Reply to Thread
Results 1 to 5 of 5

VBA Upper for multiple Columns

  1. 07-31-2017, 10:48 PM #1
    g1terra
    g1terra is offline
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    VBA Upper for multiple Columns

    I am trying to write a code for a sheet where i want to make these COLUMN ranges in UPPER CASE. I only know how to write on range only?

    B1B100
    D1:D100
    F1:F100
    H1:H100
    J1:J100
    Reply With QuoteRegister To Reply
  2. 07-31-2017, 10:59 PM #2
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: VBA Upper for multiple Columns

    One way

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
  3. 07-31-2017, 11:24 PM #3
    g1terra
    g1terra is offline
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    Re: VBA Upper for multiple Columns

    Is there a way to do automatically and not using a button?
    Reply With QuoteRegister To Reply
  4. 08-01-2017, 02:03 AM #4
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: VBA Upper for multiple Columns

    Give this a try. Goes into the worksheet module.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 08-01-2017, 05:58 PM #5
    g1terra
    g1terra is offline
    Forum Contributor
    Join Date
    06-02-2014
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    235

    Re: VBA Upper for multiple Columns

    Perfect thank you!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. To shift 5 columns to the upper row, if the upper row is empty
    By sneha1889 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-28-2014, 10:58 AM
  2. [SOLVED] VBA code to select multiple columns with upper bound (j) & lower bound(i)
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 07-15-2014, 10:56 AM
  3. [SOLVED] VBA code to select multiple columns with upper bound (j) & lower bound(i)
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2014, 12:36 AM
  4. [SOLVED] Multiple if statements with upper/lower bounds
    By crail5 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2013, 01:25 AM
  5. Sorting Cells in Columns in Excel by Upper or Lower Case words
    By Saint3r in forum Excel General
    Replies: 2
    Last Post: 08-20-2010, 03:42 AM
  6. [SOLVED] How do I convert all upper case excel sheet into upper and lower .
    By DebDay in forum Excel General
    Replies: 1
    Last Post: 03-09-2005, 05:06 PM
  7. How to change location A1 cell from upper right to upper left?
    By Doug@Peacock in forum Excel General
    Replies: 1
    Last Post: 02-08-2005, 11:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1