macros

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macros

Macros

resolvedResolved · Low Priority · Version 2003

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips


Server loaded in 0.08 secs.