Getting cell value from other sheets

[Guest]

Is it possible to get cell value from sheet2 (Active sheet is Sheet1) without
Activating Sheet2? Right now I am activating sheet2 and getting specific
range cell value - but calling sheet Activate() looks like toggling - so is
there any other way to extract cell value from other sheets wihtout actually
activation that sheet programatically? Thanks for any suggestion...

 

[Guest]

Hi Dev -
I think the easiest approach is to use a very explicit description of the
source cell in your VBA code. Something like this should work without
activating Sheet2:

x = ActiveWorkbook.Worksheets("Sheet2").Range("B17")

 

[Guest]

Thanks Jay!! this is what I am looking for...

Hi Dev -
I think the easiest approach is to use a very explicit description of the
source cell in your VBA code. Something like this should work without
activating Sheet2:

x = ActiveWorkbook.Worksheets("Sheet2").Range("B17")