Setting variable data-sort ranges

I have a macro to select a range based on various criteria either being true or false. Whichever range is selected, I would then like to datasort that range ONLY. Unfortunately i can't seem to get my code to reference a variable area to data sort.

Please Login or Register  to view this content.

The part that is causing me problems is:

Please Login or Register  to view this content.

A friend suggested changing the Range("AG4") part to Range("AG"+rng) or possibly Range("AG".rng) neither of which work.

Appreciate any suggestions you guys may have!

Thanks
Forcybo

Hi Stuie,

Thanks for your input! Unfortunately the code you have suggested still sorts from row 4 but now also sorts by column K (the first column in the range) rather than column AG as before.

I'm slowly going bald from all the hair being pulled out over this lol

Stuie - yes mate, always looking to data sort by AG (for this sheet AG is actually a customer's requested delivery date).

Royuk - the true value is determined by a tickbox. When the tickbox is checked (TRUE) it enters a value of X into the corresponding cell in Column I. Do you think this might be the issue? In a previous incarnation of this macro i played with changing the 'True' value to "X" and it didn't seem to make much of a difference.

OMG royuk you are a God amongst men! At first it gave a runtime error but then i had a little play with the back end and changed it to:

Please Login or Register  to view this content.

Works like a charm now! Thank you so much! And thank you Stuie for your time.

forcy starts gluing hair back on.