T TJF Feb 13, 2004 #1 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
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 Feb 13, 2004 #3 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
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
