Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is it possible to get cell contents from another sheet?
sheets("sheetA").range("a1").value=sheets("sheetb" ).range("a1")
or sheets("sheetb").range("a1").copy sheets("sheetA").range("a1") -- Don Guillett SalesAid Software "quartz" wrote in message ... Is it possible to obtain the currently selected cell address from another sheet (one not currently active) without actually activating that sheet OR must you activate the sheet to obtain the selection? For example, Sheet B is currently active. I want a macro that obtains the currently selected cell on Sheet A without actually having to activate Sheet A. Both sheets are in the same currently open file. If so how do you do this, or can you? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using contents of a cell as the sheet name in another formula | Excel Discussion (Misc queries) | |||
transfer contents from a cell in previous sheet if the sheet is a | New Users to Excel | |||
Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions | |||
Contents of a cell refer to sheet name | Excel Programming | |||
New sheet from the cell contents | Excel Programming |