Dynamic Ranges....

[minn]

Hi,

I have some vba code that does some sorting on a predefined range like so:

Please Login or Register  to view this content.

However, i no longer want the sort range of B5:U104 to be static as i want the user to be able to add new rows and when they click on the sort macro button, the sort picks up the newly added rows.

Can anyone help me with this?

Thanks in advance.

[royUK]

This amendment should do that

Please Login or Register  to view this content.

[minn]

Thanks,

however, it doesnt like that.

Could it be because rngSortRange is first declared as a string but then initialized as something else i.e.

' Initialise range to sort
strSortRange = Range("B5:U65536").End(xlUp)

I don't know, im a beginner so that may be complete nonsense.

Any ideas?

[royUK]

Yes, change it to Range. I would never use your strings to set ranges.

[minn]

Ammended as advised, but i get a 'run time error '1004' Application-defined or object-defined error'

Please Login or Register  to view this content.

Thanks

[junkbryan]

' Initialise range to sort

Please Login or Register  to view this content.

Can someone please tell me what the .End(xlUP) function refers to? How do I select this range to copy directly after I highlight it? I am such a newbie.