$$Excel-Macros$$ Select files via checkboxes, then copy those files to a new directory

2010-06-24 Thread Leigh
I am trying to accomplish this in Excel using VBA, and keep hitting brick walls: I would like to create a user form in Excel with checkboxes for 25 different files that exist in a source directory. I would like the user to be able to check off the files that they want to copy, and then move those

$$Excel-Macros$$ Excel VBA Vlookup row and column variables

2008-11-20 Thread Leigh Williams
I am trying to do a vlookup on my Excel spreadsheet using the following VBA code: Dim row As Integer Dim prodCodeCol As String Dim weightCol As String row = 2 prodCodeCol = "O" weightCol = "J" Range(weightCol & row).Select ActiveCell.FormulaR1C1 = "=VLOOKUP(" & prodCodeCol & row & ",'[Kogan WMS