Filtering by items that begin with a number

[pbgexcel]

Good afternoon all,

I'm look to automate the filtering of a large Excel database. I want to include in my code a bit that will be able to filter a particular column so that only the items that begin with a number (0-9) in that column are visible. I'm very comfortable with VBA and have been trying to record a macro doing this to have some code to get started with, but found that I'm not sure how to even do so manually. Any ideas how I can filter a column only on those items that begin with a number?

Thanks so much for all your help!

 

[kbrummert]

Sub Hide_Columns()
    Dim rg As Range
    
    Set rg = Selection
    Application.ScreenUpdating = False
    For Each cell In rg
        cell.EntireRow.Hidden = IsNumeric(Left(cell, 1))
    Next cell
    Application.ScreenUpdating = True
End Sub

 

[pbgexcel]

Didn't think of that! Thanks so much kbrummert!