Is it possible to get cell contents from another sheet?

G

GJones

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
 
Top