Take value from sheet

T

TJF

How can I read value (for example A1) from sheet which is not active now?
But I dont want switch to this sheet. Of course in VB.

Tom
 
N

Nick Cranham

TJF,
You can (normally) remove the .Select that are generated by the macro
recorder, as long as you take care that you are then referencing the correct
objects rather than Selection.

Nick
 
Top