Change range of columns to Uppercase

  • Hi folks


    I use the following code to change the text on a sheet to uppercase but would like to refine it so that only selected columns are changed.


    I've tried altering the Target.column to something like ="C:F" but without success, any ideas please?


    Kind regards


    DezB




  • Re: Change range of columns to Uppercase


  • Re: Change range of columns to Uppercase


    Hi pike


    That works just fine, much appreciated. Unfortunately I have another piece of VBA on the same sheet and I'm now getting a conflict:



    As you can see I'm on a steep learning curve here, but what fun....


    Kind regards


    DezB

  • Re: Change range of columns to Uppercase


    have fun

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!