Recent content by FROFESSOR

I have already figured it out. This is what I did!! Function ConnectDB() As ADODB.Connection Dim cn As ADODB.Connection Set cn = New ADODB.Connection With cn .Provider = "Microsoft.Jet.OLEDB.4.0" .ConnectionString = "Data Source=" & ThisWorkbook.FullName & ";" & _...

Hi I have a list of names and other information in a excel list that I'm preparing for a house party. What I want to do is have the results shown in the immediate window. The information I want is the Name and Sex of the Male only. How do I do that in VBA. Below I have the code that I have till...