Rick
To find the next available cell in column T, use code like this
Range("T65536").End(xlUp).Offset(1,0)
--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.
"Rick" wrote in message
...
Hi,
Could someone assist with this problem.
Thankyou
In T8 there is a heading.
T9:T110 is a data range.
I have various macros that compute groups of data which I
need to add cumulatively to the range.
The first click of a new macro must add data starting at
T9 down, say T9:T30.
The next one must add it's data to T31:?
And so on.
How do I make a macro that always starts adding data from
T9 and then with each subsequent click, adds the groups of
data from the bottom of the last data cell downwards.