ucase

  1. M

    Uppercase Date While Keeping DATE Format

    I've been attempting to format a cell while maintaining the DATE() format: MONTHNAME DD, YYYY using the following code: Sub uppercase() With Sheets("Sheet1").Range("B2") .Value = Date .NumberFormat = UCase(Format(Date, "mmmm ")) & UCase(Format(Date, "dd")) & ", yyyy"...
  2. John.McLaughlin

    Change to UPPERCASE - My VBA Macro Imports lowercase data Sheet 1 to lowercase Sheet 2?

    Hello! I use a basic order form clients fill out and send me. Then I have a VBA macro that reads every cell of the submitted form, and pastes the value into the corresponding "In House" form. Trouble lately, a few people are sending everything in lower case. Can I modify my copy or paste...
  3. I

    Argument not optional message

    Hi, Please could you advisethe issue with my UCase code Private Sub InsertNewRow_Click()Rows("6:6").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove Range("A6").Select Range("A6:Q6").Borders.LineStyle = xlContinuous Range("A6:Q6").Borders.Weight = xlThin...
  4. DataBlake

    [VBA] Using Ucase & Like With Filters

    Hello all, I'm trying to create a filter so that i can delete anything that contains "Atv", "Utv", "Duallie", and "Dually" Issues arise when those phrases are sometimes capitalized, sometimes capslocked, and sometimes lowercase. This is my first attempt with filters in VBA which does the job...
  5. rjplante

    Uppercase date format

    I am trying to use VBA to enter the date in a dd-mmm-yyyy format with the month in all caps (05-SEP-2018). I have a merged cell C4:D4 and I have the cell custom formated as dd-mmm-yyyy (easy), but no matter what I try I cannot seam to get the month to display in all caps. I have the code below...
  6. L

    Single Sheet UCase

    Any ideas on how I can force a single sheet to convert to all caps upon opening & closing a workbook? I'm currently using: Private Sub Worksheet_Change(ByVal Target As Range)Target = UCase(Target) End Sub In the active sheet but it is somewhat "laggy".
  7. bepedicino

    Requesting VBA Assistance: Uppercase columns on active sheet

    Hello, I am looking for some assistance with a VBA macro that will convert the text in columns "A" and "B" of my active sheet to upper case. If you can assist that would be greatly appreciated.
  8. J

    Excel UPPER() / LOWER() instead of VBA UCase() or LCase()

    I am working in a macro and for the sake of speed would like to use the Excel UPPER() function instead of VBA's UCase(). I am failing to find it among the Excel objects. I thought it might be part of WorksheetFunction, but that is not the case. Is it useable from VBA?
  9. E

    UCase Question - VBA

    Hi, I'm trying to copy a list of cells in uppercase..I tried this, but to no avail: Range(Cells(124, 1), Cells(128, 1)) = UCase(Front.Range("B6:B10")).Value It works without the UCase.. Anyone got any ideas? Cheers, E

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top