Another way ... non-volatile:
Enter anywhere and copy down:
=INDEX($1:$1,ROWS($1:2))*24
Enter anywhere and copy across:
=INDEX($A:$A,COLUMNS($A:A))*24
--
HTH,
RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===
"Anne1320" wrote in
message ...
Thank you, Duane! That worked fine, and while my actual project is a
little different from that exact example (some includes text, and not
always on the same sheets, I've now got a good way to tackle the
specifics.
Appreciate your help.
--
Anne1320
------------------------------------------------------------------------
Anne1320's Profile:
http://www.excelforum.com/member.php...o&userid=35969
View this thread:
http://www.excelforum.com/showthread...hreadid=557570