Copy a cell

[jcc31]

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 |
+-------------------------------------------------------------------+

 

[Gord Dibben]

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

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


Gord Dibben Excel MVP