MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Private Sub CommandButton2_Click() Dim NameList() As Variant Dim dict As Object, c As Variant, i As Long, lr As Long Set dict = CreateObject("Scripting.Dictionary") lr = Cells(Rows.Count, 1).End(xlUp).Row c = Range("a1:a45" & lr) For i = 1 To UBound(c, 1) dict(c(i, 1)) = 1 Next i End Sub
|Combine like values in a graph excel 2016||7||35|
|Application.FileSearch does not work in excel 2016||2||22|
|enable formatting rows through Thsworkbook VBA code||5||15|
|How can I calculate a balloon payment in Excel?||5||15|