Hello All,
I have attached a workbook with three different worksheets showing three different possibilities. In all three instances, the macro should take me to a different macro and run it (call it) depending on the values found in the spreadsheet. In the first scenario, the macro (let's name it "macro test") finds both "A" (xlWhole) and "P" (xlWhole) in column E. Therefore, macro test should call Macro "Both". In the second scenario, macro test finds only "A" (xlWhole). Therefore macro test should call Macro "A". In the third scenario, macro test finds only "P" (xlWhole). Therefore macro test calls Macro "P".
Macro test ends upon calling any of these three macros.
I look forward to your reply.
Best,
Andrewstupendo
Bookmarks