lrb

I have the following script Sub ListAllFile() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim ws As Worksheet Dim sPath As String Dim lrA As Long Dim lrB As Long Set objFSO = CreateObject("Scripting.FileSystemObject") Set ws = Worksheets.Add 'Get the folder...

How can I modify this code to list the folders within a directory? I tried ... unsuccessfully Sub ListAllFile() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim ws As Worksheet Dim sPath As String Dim lrA As Long Dim lrB As Long...

Hi Everyone! Happy New Year! I am trying to make my VBA faster - It is pretty slow for now (30 secs) <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; min-height...

I am trying to modify my macro 1) to have order not matter in the columns 2) show what is missing from either column 3) sort the results in lowest to highest example column 1 column 2 5 3 1 1 7 5 2 7 Sub Compare() ' ' Compare Macro '...

Hi. I'm trying to lookup each value of table1 in table2 giving the second column. In table2 data is sorted. TABLE1... LOOKUP VALUE RESULT A A1 A A2 A A3 A A4 B B1 B B2 B B3 C C1 B B1 B B2 B B3 TABLE2.. COL1 COL2 A A1 A A2 A A3...