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

"Frank Kabel" wrote in message
...
Hi
try
worksheets("sheetx").range("A1").value

Frank

Worksheets
TJF wrote:
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