Thread
:
Is it possible to get cell contents from another sheet?
View Single Post
#
1
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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 With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]