How do i get my macro to accept the userform text box value that I enter.
I know how to
I want to saveas ppt file to mp4 video. ( from one folder to another folder)
Const prefix1 As String = "BCN"
Const prefix2 As String = "EX"
Private Sub Worksheet_Change(ByVal Target
if you use autofilter
Dim dic As Object, a, v, i As Long, e
Please try this.
Dim r As Range
Dim c As Range