visual basic - select/activate but don't show sheets
 

Hi,
I'm trying to make a nice user interface on one worksheet. When I access
cells in other worksheets using select or activate, the view automatically
switches to the other worksheet. Is there any way for me to get the values
in cells on other sheets, but keep the view on my one user interface
worksheet?
Thanks in advance for any help.
Donna

visual basic - select/activate but don't show sheets
 

You (almost) never need to Activate or Select anything in Excel/VBA. Just
reference the cell directly:

Dim V As Variant
V = Worksheets("SomeSheet").Range("A10").Value
Worksheets("SomeOtherSheet").Range("B20").Value = V

or, as a one liner

Worksheets("SomeOtherSheet").Range("B20").Value = _
Worksheets("SomeSheet").Range("A10").Value


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Donna Edwards" <Donna wrote in message
...

Hi,
I'm trying to make a nice user interface on one worksheet. When I access
cells in other worksheets using select or activate, the view automatically
switches to the other worksheet. Is there any way for me to get the
values
in cells on other sheets, but keep the view on my one user interface
worksheet?
Thanks in advance for any help.
Donna