Getting the correct Syntax for Range in Sorting

**highlystrung** · 08-30-2011, 04:16 PM

Hi all,

I'm trying to get the correct syntax for identifying the range in a variable sized table on sorting. The line using a fixed range reference - Range("E2:E296") - works but doesn't cater for the changing table size. I've tried syntax in the line above to correct this but it's giving me an error. Can anyone advise what the correct syntax is please,

thanks, Neil

Please Login or Register  to view this content.

**TMS** · 08-30-2011, 04:22 PM

Try:

Please Login or Register  to view this content.

Regards

**highlystrung** · 08-30-2011, 04:30 PM

That seems to do the trick, thanks alot. How do you learn / work out these complex syntaxes....!?! regards, Neil

**TMS** · 08-30-2011, 04:50 PM

Well, once upon a time, I was asking exactly the same questions. It just takes time and practice. Monitoring the questions and answers in the forum is a great way to learn ... and asking questions.

Regards