G Guest Mar 16, 2004 #1 Got column A1 thru A?. What macro coding to copy that last (A? variable number on entries) cell to K1? Thanks.
Got column A1 thru A?. What macro coding to copy that last (A? variable number on entries) cell to K1? Thanks.
F Frank Kabel Mar 16, 2004 #2 Hi without a macro (and if there a no blank rows in between) try the following formula in K1: =OFFSET($A$1,COUNTA(A:A)-1,0)
Hi without a macro (and if there a no blank rows in between) try the following formula in K1: =OFFSET($A$1,COUNTA(A:A)-1,0)
G Guest Mar 17, 2004 #3 Thanks Frank. Easy to tweek into Macro... Range("K1").Select ActiveCell.Formula = "=offset($A$1,counta(A:A)-1,0)"
Thanks Frank. Easy to tweek into Macro... Range("K1").Select ActiveCell.Formula = "=offset($A$1,counta(A:A)-1,0)"
