Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how get cell value from different worksheet?
Thanks in advance.
I have a macro in Worksheet_SelectionChange, so it runs every time I change the selection, and I want to get a value from a cell in another worksheet. I figure if I have to, I can do this by changing worksheets (Worksheets ("Sheet1").Activate) and then getting the 'Cells (x,y).value', but is there another way I can do this so I don't have to change worksheets (and save processing time)? Something like Worksheets("Sheet1").Cells (x,y).Value (but which doesn't exist). My code is (this is Sheet4) Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'get value of row 1,col 1 cell value of sheet1, let = x. Select Case x Case "A" 'code here Case "B" 'code here End Select End Sub Thanks again. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to name worksheet tabs using a cell within the worksheet? | Excel Discussion (Misc queries) | |||
Linking Tab/worksheet names to a worksheet cell | Excel Discussion (Misc queries) | |||
copy cell from one worksheet to another worksheet in exel | Excel Discussion (Misc queries) | |||
Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions |