| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Take value from sheet
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Take value from sheet
Hi
try worksheets("sheetx").range("A1").value Frank Worksheets TJF wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Take value from sheet
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 "Frank Kabel" wrote in message ... Hi try worksheets("sheetx").range("A1").value Frank Worksheets TJF wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| "='sheet 1'!D4" auto fill sheet to sheet ='sheet 2'!D4 | Excel Worksheet Functions | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
![TJF[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
