Sort Range Problem

Hi,

Please see the almost identical point made in post #4 of this http://www.excelforum.com/excel-prog...y-of-rows.html thread which I posted just now.

You should create a dynamic range name and use the name in your macro.

Yes, I see it now. Thank you, Richard.

I was just coming back to report that I'd found a solution - which is similar in concept to your ideas.

Please Login or Register  to view this content.

- and now I see your followup about the value of dynamic range names. I'll study that too.

Thanks again for your help.

- Fred

Hi,

As a general principle it's always more efficient to use standard Excel functionality rather than VBA code. Which is why a dynamic Excel range name is better.

What you have will of course work but you are open to problems with someone adding a row and your code not finding the last row correctly, not to mention having to use string slicing code in the macro.

Dynamic range names are simple and once created you can forget about them.