Forum Discussion

jukhamil's avatar
jukhamil
Brass Contributor
Sep 17, 2021

Filter a column for entries starting with capital letters

I would like to hide all entries in a column (except the header) which do not begin with a capital letter, i.e. the symbols A, B, C, ..., Z.

 

How would I do that with a VBA macro?

 

Thank you very much.

Macros and VBA

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Sep 17, 2021

    jukhamil You could add a helper column to the table and use a formula to determine if the CODE of the first character is between 65 (=capital A) and 90 (capital Z), resulting in TRUE or FALSE. Then filter to show only TRUE. See attached.

    • jukhamil's avatar
      jukhamil
      Brass Contributor
      Sep 17, 2021
      Thanks very much. I'd like to use this CODE syntax to determine if a cell begins with a capital letter or not. But I'd rather just apply a filter based on that condition, in VBA. So I'll keep looking into how to do that. Thank you very much for your insight

Resources