read from hidden sheet
 

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

read from hidden sheet
 

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.

---
Per

On 6 Maj, 22:48, "greg" wrote:
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