Ok. I want cells to be displayed not automatically in a period of time. Any
time I run the macro it copy and paste it from the range one by one to a
different cell.

EX. I have data in range A1:B5. when I run the macro, A1 cell would be copied
and pasted in cell, lets say D1. I run the macro again and this time it would
show A2 in D1 and so on till B5.

The purpose of this is that I have many names in cells and when a user hit
the botton (which I will make to run that macro), it shows their turn.

Thx.

D. wrote:
Do you want the cell values to show individually, like 1/sec or
something like that??

and what would be the purpose of this, besides it becoming annoying?

--
Message posted via http://www.officekb.com