Window_Activate

  • Thread starter Thread starter Gianluigi
  • Start date Start date
G

Gianluigi

Hello,

in a macro I need to switch from a sheet (always the same) to another
sheet whose name change every time. The sheets opened simultaneously are
always only two. How can I do to have in the command
Windows("Cartel1.xls").Activate a variable reference ?

Thanks


Gianluigi
 
in a macro I need to switch from a sheet (always the same) to another
sheet whose name change every time. The sheets opened simultaneously are
always only two. How can I do to have in the command
Windows("Cartel1.xls").Activate a variable reference ?

Thanks


Gianluigi
Click to expand...

I reply to my own answer: the command to use is "ActiveWindow.ActivateNext"

Gianluigi
 
Back
Top