I'm trying to call a subroutine on one sheet from a different sheet in the same workbook. What am I missing? The example bellow works when the subs are on the same page. I tried inserting in Sub Test1 a line selecting the worksheet in which Test2 resides, but that didn't work.
Sub Test1()...