98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros
Macros
Resolved · Low Priority · Version 2003
Tue 24 Jun 2008, 14:11Delegate Nasif said...
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
Thu 24 Jul 2008, 13:35Trainer Carlos said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use shortcut keys to select rows or columnsMost users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that. |
