View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default How to set up macros that will work when aditional data is added

Use a loop to get the last filled row.

OR

The below will give you the last filled row in Column A.
lngLastRow = ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row

If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

I want to write macros that will automatically update the spreadsheet when I
add further data. For example I have 10 columns x 8 rows of dat and write a
macro to generate average and standard error of the mean in the cells below
each column. Later, when I get the results from the next set of experiments
I insert a further 8 rows of data giving me 16 rows in all. Is it possible
to construct a macro that will handle this or do I just have to insert the
formula again this time for 16 rows?

This may sound trivial but we have lots of data accross many different
experiments and it would be more elegant and efficient if I could produce a
spreadsheet that our students could just paste their results into that would
do the necessary calculations for them.
--
medjpb