I am trying to read data from a hidden sheet in vba.
If i have a sheet "test1" that is visible. and "test2" which is hidden.
in my code i say
sheets("test2").Activate

in the watches window
Excel.ActiveSheet.Name = test2

on the next statment I execute the sheet switches back to test1
Excel.ActiveSheet.Name = test1

is there some trick?
do i have to make the sheet visible?

thanks