accessing a specific cell of a copied range...

[Laura]

In a macro I am currently writing, I have selected and copied an entire row on a spreadsheet. I need to assign the value of a certain cell in that row to a variable, and I can't find a way to get to it. For example, if row 10 was selected, and i had a variable x, and i wanted x to equal the value of cell C10, is there a way to do that?

[Al Chara]

Not sure I understand, but to set a variable equal to a cell, do the following:
x=[c10].value

or

x=range("c10").value

or

x=cells(10,3).value

or

etc.