rngname

Hello, I have a userform with some comboboxes and commendbuttons, one of the comboboxes named "cmb_Name" In Sub UserForm_Initialize, I have below peace of code to show the suppliers names in the combobox Dim rngName As Range Dim ws As Worksheet Set ws = Sheet8 For Each rngName In...

I am trying to obtain the name of a named range passed to a UDF. I want to use it in error messages. Based on previous discussions and an Internet search, I came up with this, which doesn't work. Public Function ShowRangeName(rng As Range) Dim rngname As String rngname = rng.Name.Name MsgBox...

Hello, I have the small pasted VBA below. I was wondering what code can I add in so that if it cannot find, it will move onto the next find? Thanks! Dim rngName As Range Set rngName = Range("L1:CA1").Find("Name") Range(rngName, rngName.End(xlDown)).Select Selection.Delete...