sorry, missed your last requirement
this would go on the userform's activate code page
and you should qualify the ranges with the sheet names

Public Sub buildRubric_Activate()
Worksheets("Sheet1").Range("C2").End(xlDown).Offse t(1, 0) = _
Worksheets("Sheet1").Range("H24")
End Sub





--


Gary


"elrussell" wrote in
message ...

I am guesssing that this is a problem in search of a programming
solution. Two cases:
[1] I have textual content in cell H24 that I want to copy to the first
empty cell in column C.
[2] I would like to insert some system variables such as today's date,
time, etc.

I would prefer to do all of this when a given form (buildRubric) is
initialized. Any suggestions will be greatly appreciated.

Thanks in advance!


--
elrussell
------------------------------------------------------------------------
elrussell's Profile:
http://www.excelforum.com/member.php...o&userid=31020
View this thread: http://www.excelforum.com/showthread...hreadid=521437