Hi All,
Question re. macros. Im not a programmer thats writes them but someone who
simply records and plays. Got a question about something....

Lets say I have formulae in cells D2, E2 and F2.
I have data in A2, B2 and C2 down to A10, B10 and C10.

Record Macro.
I Copy formulae in D2,E2 and F2 down to D10, E10, F10 top match the data rows.
This is fine when I run the macro where the data is always to row 10.
what about if my data in a,B,c goes down to Row
a) row 20 - i am left with 10 rows where the formulae does not copy
b) row 5 - I have rows of formula not needed (as i pivot table the results
this is a pain).

What I want it every time i run the macro to copy the formulae down to the
last row of data, where everit may be.

When i do it manaully, i get the mouse pointer into the bottom righ corner
of cell F2 (where D2,E2 and F2 are all highlighted), the pinter turns into a
small black cross and i double click to copy the formula down to the last row
where there is data in c. This is what I want the macro to achieve. I tried
copying this mouse stroke but it always on running goes downt to the same row
every time.
Thanks
rob
--
Rob Gaffney