Nasif has attended:
Excel Advanced course
Macros
Hi
SImple question on Macros
I do a lot of anlaysis where I dump in data into a sheet which then links upto loads of formulas.
How do I create a Macro which does a simple formula with the data but copies it down the length of the data. for eg.
I have data with 200 rows. I record a macro simply adding 2 columns together and copy it down.
Now when I put in the new data which is say 300 rows and run the macro, it stops short at 200 rows, how do I get it to automatically pick up the no. of rows and copy the formula down?
Thanks
RE: Macros
Hi Nasif
If the macro always stops at 200 rows there must be a line of code in the macro stopping the procedure at that point every time. It was probably recorded that way.
Which means you may need a bit of code that checks that the cells being calculated are populated (checks how many rows there are). You may need to make the code more dynamic.
You could send me the macro code and I'll try and workout what the problem is.
Regards
Carlos
