+ Reply to Thread
Results 1 to 4 of 4

Macro to change all column headers to Uppercase (i.e. CAPITAL) letters.

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    466

    Smile Macro to change all column headers to Uppercase (i.e. CAPITAL) letters.

    Hi,

    What I would like is a macro to search all my column headings i.e. column A through to column IV and change the text to all Uppercase (i.e. CAPITAL letters).

    Any assistance in this matter would be greatly appreciated

    Many thanks in advance


    Rob

    N.B. Excel version 2003
    Last edited by robertguy; 12-08-2010 at 10:06 AM. Reason: To mark Solved
    Rob

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,117

    Re: Macro to change all column headers to Uppercase (i.e. CAPITAL) letters.

    Enter this line in the immediate window within VBE

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016
    Posts
    3,392

    Re: Macro to change all column headers to Uppercase (i.e. CAPITAL) letters.

    Hi,

    Does this do it for you?

    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  4. #4
    Forum Contributor
    Join Date
    02-09-2004
    Location
    Cardiff - Wales - UK
    MS-Off Ver
    2013
    Posts
    466

    Re: Macro to change all column headers to Uppercase (i.e. CAPITAL) letters.

    Andy & Sweep

    many thanks for your prompt reply your code worked a treat

    Thanks again

    Rob

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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