always last active cell

[sal21]

... write always the value of last active cell from the range G2:BN2 o
sheet RATE into O2:O20 of sheet ANAGRAF

Attachment filename: provarate.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=42049

 

[Dave Peterson]

You can use formulas like these from a post by Aladin Akyurek:

========

If F is numeric,

=LOOKUP(9.99999999999999E+307,F:F)

will fetch the last value in F.

=MATCH(9.99999999999999E+307,F:F)

will return the position of the last value in F.

If F is of 'text' type, replace the big number in the above formulas with
REPT("z",255).


========
And I didn't open your attachment. Many people won't--too many threats of
malicious code. To get the most varied response, you'll want to post in plain
text with a text explanation.