macro only executes to a specific range and then stops

[johnmerlino]

Hey all,

I have this macro:

Please Login or Register  to view this content.

The problem is it executes to a specific range and then stops. So it will stop at row 360, despite the fact that column a can have more rows. Is there a way to get this thing to run the length of column a, where column a has content in its cells?

Thanks for response.

[JBeaucaire]

Like so:

Please Login or Register  to view this content.

[johnmerlino]

Thanks that worked perfect.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.