What do you mean by "highlighted". HTH Otto
"J@Y" wrote in message
...
I need something that is to the purpose of:
if the cell is highlighted, copy the row and paste it here.

What is the code for testing whether a cell or row is highlighted?

Thanks.