Have a look at Ron de Bruin's site for VBA macros for copying.

http://www.rondebruin.nl/copy1.htm


Gord Dibben Excel MVP

On Tue, 5 Jul 2005 15:01:05 -0500, jcc31
wrote:


Hi,
Can you guys help me out? My problem is that I'm trying to copy the
last viable cell onto another sheet. I have to sheets, one "TOTALS" and
"TIME". On the TIME sheet I'm trying to copy the last valid cell under
the Bakroll Balance to the TOTALS sheet that way I can see a running
total. Here is my file.

Thanks


+-------------------------------------------------------------------+
|Filename: Texas Holdem.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3573 |
+-------------------------------------------------------------------+