Getting cell value from other sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

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...
 
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")
 
Thanks Jay!! this is what I am looking for...

Jay said:
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")
Click to expand...
 
Back
Top