Posts by peterkin

    Hi all, I have a question when using sorting function in VBA.

    I have a table which have around 30 rows.

    I would like to sort the date of 10 rows within the table (say row 11-20 only) and do not want to affect other rows.

    I created the following commend in VBA but fail to do so.

    I selected rows 11-20 but it sorted the whole table.

    How can I fix it?

    Thank you