View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika Dick Kusleika is offline
external usenet poster
 
Posts: 179
Default Macro to add data

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.