I am having issues with the code for my if...then... else loop:
Basically, I have a range named "MyRange" in my worksheet (column B1:B10) which contains the True/False from a checkbox in column A1:A10. In column C1:C10 I have text names (ex Schedule) which is the name of the file in another file path (I have the path to where the files I want opened named MyPath = ....). What I would like to write is something like:
If MyRange is True
Then Open wb MyRange.Offset(0,1).Value that is located in MyPath & "/" & "xls"
Else move on to the next row in the True/False column
Solved: IF...ELSE...THEN LOOP HELP Please Help!
Reply With Quote