Is it possible to get cell contents from another sheet?
 

Hi Quartz;

Use the following in a macro

'makes a string of the address for the active cell
varMyAddress = ActiveCell.Address
'variablizes the value for the cell located in the other
work sheet while using the address from the original sheet
QuartsAnswer = Sheets("Sheet1").Range(varMyAddress)




Thanks,

Greg
-----Original 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.
.