What does this mean:
when i shade a box
What does shade mean and what is a box.
Do you mean when you select a cell inside a table.
So when you select Cells(2,1) in Table1 you want to copy this cell where.
What is the Table name?
I asked two questions:
What is the name of the Table.
And copy the cell where and you did not answer either question.
Saying copy cell to other sheet is not specific.
And when you say shade. Do you mean interior color is Green?