Take value from sheet

  • Thread starter Thread starter TJF
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find the correct sheet then find a value on that sheet 8
Progressive number in different sheets 7
clear all sheets code 4
sheet event wait for another event? 6
entering value without acivating sheet 4
Value from one sheet paste under same value on other sheet. 7
Updated sheet content is not copy pasting from sheet1 to sheet2 2
Convert A1 value to a sheet name and copy to it 2

Back
Top