It is almost always unnecessary to Select a range before using
it. For example,

Dim Var As Variant
Var = Worksheets("January").Range("A12").Value
' or
Worksheets("January").Range("A12").Copy


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ornit " wrote in message
...
hello all
I have a question:
I'm trying to use values from different worksheets but I don't
know how
to do it without using the "select" command, I don't even know
if it's
possible.

Here is an example:

Sheets("january").Select
Range("A12").Select
Selection.copy

Can I get the value without "selecting" it first?

thanks


---
Message posted from http://www.ExcelForum.com/