excel-courses - Macro

Hi Diana

If you have already defined the range in a macro this needs to be edited so that the computer picks up the new range every time. To do this:

Lets say the range in the macro is

Range (A9:Z250).Select

Now since in the example the data always starts at "A9" and you don't know if you are adding more rows or columns then you need to edit your range in the macro as follows:

Range("A9", Range("A9").End(xlToRight).End(xlDown)).Select

This takes cell "A9" as the starting point and highlights all the adjacent columns and rows in the range that contain data.

Hope this helps

Carlos