ExcelBanter - selecting target sheet as an input

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - selecting target sheet as an input (https://www.excelbanter.com/excel-programming/404774-selecting-target-sheet-input.html)

Yossi evenzur[_2_]

selecting target sheet as an input

Hi
how can i select another sheet from the current one during a macro by
clicking on the sheet tab? e.g. clicking on the target sheet will serve as an
input for the macro to execute something io it

All times are GMT +1. The time now is 01:57 PM.