Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using visual basic to select what paper to print on | Excel Discussion (Misc queries) | |||
Activate check "Trust access to Visual Basic " in Excel | New Users to Excel |