read from hidden sheet

[greg]

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

 

[Per Jessen]

Hi

You don't have to active a sheet to read values from the sheet.

Dim Sh2 as Worksheet
Set Sh2=Worksheets("test2")

MyVal=sh2.Range("A1").value

Hopes this helps.